G
Guest
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
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