Help with automation...

[help_questions]

I have an excel report that i functional.
What I need help is is incorporating access into the macro running the report. I have a make table query that I need to have my excel macro execute. Can this be done? If so, how.....

 

[Smitty]

Sure.

Goto Data-->Import External Data-->New Database Query-->Follow the Wizard to set up your query. Once it does what you want you can record a macro refreshing the query and either add the code or call it from yours.

HTH,

Smitty