View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rob Stewart Rob Stewart is offline
external usenet poster
 
Posts: 2
Default 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