Access automation: Running a macro from one Excel Spreadsheet to a

  • Thread starter Thread starter mattieflo
  • Start date Start date
M

mattieflo

Hello,

I have these reports that get saved to an excel file. What I need done is to
have these reports formatted in a certain way so that I can import them
cleanly. (Remove unnecessary rows, format headers correctly). I'm trying to
figure out the best approach. I have an excel macro which I can run from
access by hitting a button which formats the report and imports it cleanly.
The problem is that the user must cut from one excel file to the excel file
with the macro. Does anyone have a better approach?
 
What happens is the user has a report that has an "Export to excel" function.
If I have them export to the excel file which the macro is located on, it
will write over that file and thus the macro itself. I have to have them save
to a different file. I think I get what you're saying. Why not have them save
to a location each time and then have the macro cut from that file and paste
 
Back
Top