View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Simon Murphy Simon Murphy is offline
external usenet poster
 
Posts: 30
Default do anybody have a sample code for executing excel macro from vb code?<eom

xlapp.run "macroname", any arguments [the ugly way]
or callbyname
or wb.ws.yourProc
if you post your vb code and vba routine and I'll do a full example
Access is cleaner if your vba code is in classes either your own or behind
the excel objects
cheers
Simon

"B Deepak" wrote in message
...