Automatic Report Exporting

  • Thread starter Thread starter akemeny
  • Start date Start date
A

akemeny

I'm working with Access 2003 on a company project. We have an excel
spreadsheet that is linked to our main data. That linked spreadsheet is then
linked to an Access table to enable us to run certain reports faster. What I
need is a macro or VBA that will automatically update the report and then
export a copy of the report to a specific excel workbook.

For example:

I have a report run called Master. Every Friday the Master report needs to
be updated and exported to Excel.

Is this possible??
 
I tried doing a Macro for OutPutTo, but it keeps giving me a Type MisMatch
error. For some reason when it goes to Export the report to Excel it won't
read the xls as a file type. It keeps trying to export as "All Types". Even
when I specify in the Macro to export to Excel 97-2003 it still does that.
How can I change that?
 
Back
Top