Running Excel Macros through Access

[Bob]

Is there a way to do this? I have an excel macro and an access macro set up
for the same process. Can I write something which enables me to run both of
these macros under the same macro?

 

[Ken Snell [MVP]]

It's possible to run an EXCEL macro in a workbook from ACCESS via VBA using
Automation. You can call VBA code from an ACCESS macro.

You'll need to tell us more details before we can suggest ideas.

 

[Bob]

I have an excel macro which formats a text file for import into access for
further manipulation. Currently the process is 2 Steps (Running the excel
MAcro and then running the access macro) and I was wondering what I needed
that to do to get that to all run under the access macro

 

[Ken Snell [MVP]]

Chances are that the EXCEL macro could be recoded to be an ACCESS VBA
procedure.

Post the EXCEL macro's code and let's see.