Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to automate opening multiple workbooks.
For testing purposes, I wrote a simple macro entered with pgm.xls, which is simply Sub macro1( Workbooks.Open Filename:="D:\My Documents\jeri\Book1.xls MsgBox "continue Workbooks.Open Filename:="D:\My Documents\jeri\Book2.xls End Su I assigned the above macro1 with the keyboard shortcut key Control-Shift-T. The macro runs fine if I select to run it "manually" (under menu bar, select macro, and so on.) But if I try to run the above macro with the keyboard shortcut, it only open book1.xls and stops I want to make life simpler by using keyboard shortcut. What should I do to make it work? Do I need to build a custom toolbar or what |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Run Macro In All Open Workbooks | Excel Discussion (Misc queries) | |||
Macro to merge open workbooks | Excel Discussion (Misc queries) | |||
macro or code to open multiple workbooks | Excel Discussion (Misc queries) | |||
Macro that will add data from multiple workbooks to the 1st open r | Excel Discussion (Misc queries) | |||
help with macro to open and close workbooks | Excel Programming |