Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to run an excel Macro in VB?
Hello everyone, I have a macro already defined in an excel workbook. I
other words, if I open the workbook, and push alt+F8, it wil 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 workboo and then runs the script. Help? Thank -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to run an excel Macro in VB?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
Excel Macro Issue Trying to autorun Macro Upon Opening Worksheet | Excel Programming |