Access macros that run excel macros (1 Viewer)

pltnsgt

New member
Local time
Today, 09:08
Joined
Sep 27, 2006
Messages
9
I am trying to create a macro that will open and excel file and run the excel macro, and then run the Access macro in the data base. I currently have the macro built in excel and it runs perfectly. Not sure if it matters, but I am transferring data from text, to excel, and then importing the data into access. Any ideas?

Also, how do you turn off the box that asks if you want to delete the records when then macro is deleting files? Thanks.
 

Ziggy1

Registered User.
Local time
Today, 16:08
Joined
Feb 6, 2002
Messages
462
What does the Excel Macro do? Are you converting a CSV type file? If so Access can import the text file. You can then use other methods to organize the data.

Just clarify that first.
 

Users who are viewing this thread

Top Bottom