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

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

mattieflo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Open an excel spreadsheet and run a macro from Access VB 2
Import 4 Different Excel Files from One Folder 0
Automating Excel report Using Data from MS Access 3
Import an Excel Macro via automation 1
Running Excel Macro with Access command button 3
Running excel macro from an Access Macro 3
from access using automation run excel macro 2

Top