Automatic Report Exporting

[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??

 

[Alex Dybenko]

Hi,
I think you can use docmd.OutputTo or OutputTo macro action to export
report to excel. But this will make a separate file, so then you need copy
data from one file to another

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[akemeny]

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?

 

[Alex Dybenko]

Hi,
ok, make a backup copy of your report and try to delete columns one by one,
to find out which one cause the problem. Perhaps this will help then:
http://accessblog.net/2007/03/export-mixed-type-data-to-excel.html

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com