Launch Excel vba macro from Access?
Can anyone provide a simple way to call a piece of VBA code in an Excel
spreadsheet, from within VBA in an Access project?
I have a rather long winded approach of opening the spreadsheet via a
command shell in Access, and passing in command line parameters that then
trigger code in the auto_open() code...but I'm hoping for something a bit
simpler?!
Cheers,
Rob
|