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

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" <(E-Mail Removed)> wrote in message
news:13873D17-FCF1-45F5-A652-(E-Mail Removed)...
> 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?

"Alex Dybenko" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:13873D17-FCF1-45F5-A652-(E-Mail Removed)...
> > 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??
>

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...-to-excel.html

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


"akemeny" <(E-Mail Removed)> wrote in message
news:39345FD3-EEF9-402F-90BB-(E-Mail Removed)...
> 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" wrote:
>
>> 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" <(E-Mail Removed)> wrote in message
>> news:13873D17-FCF1-45F5-A652-(E-Mail Removed)...
>> > 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??
>>