Help with a macro please...

[klg]

We are working with a massive database that I have to run daily reports from.
I have created a macro in Access to output those reports to a directory on my
virtual hard drive. I have created a macro in Excel to transfer those reports
to an Excel workbook so they are all in place, format each sheet and close
the originating sheet. Is it possible to have a macro that will do all of
this? Send each query (70 of them) to the workbook and format each sheet. I
have buttons in my workbook that will do various things, but I would like to
be able to press one of them to retrieve the reports from Access and have
them go directly to my workbook.

Thank you,
Kelly

P.S. I have to use the cheater in macros and record. I’m not fluent in
Virtual Basic to create them without “cheatingâ€, but I do know how to go to
the properties and edit.

 

[klg]

After reading through more posts, I realized I might be able to what I really
want to do, I’m just not sure how to accomplish it. Ultimately here’s what I
need to do: With a macro, I want to retrieve reports from the database. That
information needs to go to a master spreadsheet, format what it transferred
and then transfer that information to another workbook set up for a specific
company.

I keep all companies in one master spreadsheet and then each company has
it’s own workbook so that I can email them their information individually and
file it accordingly.

I created a macro to do everything but automatically pull the information
from Access – I have a macro in Access that will send it out and another one
in Excel to do all of the transferring and formatting, but I would like to do
it all with one.

 

[Magius96]

Check out TransferSpreadsheet. You can use that to export the data into
seperate tabs in one workbook. The catch is that the name of the queries
exported will become the name of the tab.

You may also want to take note, that once you have it exported once, you can
open the workbook and set your formatting the way you want it. After the
first export, transferspreadsheet wont mess up any formatting that is saved
in the workbook, it'll just over-write the data.