Help - importing to and formating in excel

[Guest]

I have a report that I export to excel (each time, exported as a new file).
Once it is in excel I need to format it.

I believe I can do it either of two ways : 1) use Access to run a macro
written using VBA for excel or 2) export the data to the 2nd page in the
excel sheet, run a macro to copy the data to the first sheet and format it at
the same time.

I don't know how to get access to run excel code OR how to get access to
export the data to page 2 in a work book. Any help or advice would be
appreciated.

Cheers

 

[Tom Wickerath]

Hi Susie,

I think the easiest method is probably to base the newly created Excel spreadsheet on a saved
Excel template. You can do this using VBA code from within Access. There is a recent article in
Access-VB-SQL magazine, within the last 6 months I think, that shows how to use code to chart SQL
Server data in Excel. It is based on the idea of using a pre-defined template file in Excel. I
think this might be the article in question:

http://accessvbsql.advisor.com/doc/14390

You can call them at 800-336-6060 to determine how much they would charge for this article. I
suspect that a small investment here would save you a lot of hours of frustration.

Tom
____________________________________


I have a report that I export to excel (each time, exported as a new file).
Once it is in excel I need to format it.

I believe I can do it either of two ways : 1) use Access to run a macro
written using VBA for excel or 2) export the data to the 2nd page in the
excel sheet, run a macro to copy the data to the first sheet and format it at
the same time.

I don't know how to get access to run excel code OR how to get access to
export the data to page 2 in a work book. Any help or advice would be
appreciated.

Cheers

 

[Guest]

Thanks for the advice, however, I am trying to do this for work who are
unlikely to pay for anything!

 

[Tom Wickerath]

Your choice. Some people consider their time worth money as well. Apparently you don't value
your own time?

If you can purchase a reprint of this article for a few dollars, and it saves you lots of hours
of frustration, then wouldn't it be worth it, even if you were the one who made the investment in
your own education?

Tom
__________________________________


Thanks for the advice, however, I am trying to do this for work who are
unlikely to pay for anything!

__________________________________