View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default How to run an excel Macro in VB?

Hi
you may put your macro code in the workbook_open event. This way it
will automatically run at startup

--
Regards
Frank Kabel
Frankfurt, Germany

"Jonx " schrieb im Newsbeitrag
...
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/