View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jerry h jerry h is offline
external usenet poster
 
Posts: 3
Default Open two new workbooks with macro

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