Ok I have a macro in access 2000 that runs a query and then outputs the data to an excell spreadsheet. I have a macro set up in excell that will process the data and get it ready to send back to access via import queries (needed an running sum in a query couldn't figure any other way to do it, but anyway..)to put into a tempory table. My question is two fold.
1. Is there a way that I can run the macro in excell from access and have it all work in the backend(user can't see)..
and
2. How do I pause the access macro untill the excell macro is finished running and then resume when it is done?
any help on this would be appreicated
Thanks RBE
1. Is there a way that I can run the macro in excell from access and have it all work in the backend(user can't see)..
and
2. How do I pause the access macro untill the excell macro is finished running and then resume when it is done?
any help on this would be appreicated
Thanks RBE
