really need VBA code

[AndreLaplume]

I have vba executed by Ms Access to open and Excel wrkbk, refresh all pivots and save. I want to add code to invoke a macro in that wrkbk but I am unsure what it would look like...help would be gretaly appreciated!!!!

 

[Andrew Poulsom]

You should be able to use Excel's Run method. Example here:

http://www.access-programmers.co.uk/forums/showthread.php?t=28700

 

[AndreLaplume]

worked out fine...THANKS!!!!