Thread: How to run an excel Macro in VB?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default How to run an excel Macro in VB?
oxlApp.Run "Myworkbooks.xls!Macro1",arg1

--
Regards,
Tom Ogilvy

"Jonx " wrote in message
...
Hello everyone, I have a macro already defined in an excel workbook. In
other words, if I open the workbook, and push alt+F8, it will
automatically run the macro, I was curious how I would run this in VB?
I am creating a program in VB that populates the cells in the workbook
and then runs the script.

Help?

Thanks


---
Message posted from http://www.ExcelForum.com/



Reply With QuoteReply With Quote