I have a problem there is a standard company form (not VBA GUI) this a normal spreadhseet that has been formatted with fields in various locations all over the page. How do i point my access DB to these fields and extract the data.
There is a wizard that creates a link between an Excel template and a database of any flavour (provided that you have the drivers for it) - I once played around with it, but couldn't see a use for it.
For more information, open Help in Excel and type "What is the Template Wizard with Data Tracking?" into the search box.