Open Workbook From Macro Using Variables

When the "Workbooks.Open" method is executed from a Macro initiated by a keyboard shortcut the code following the open is not executed. When the same code is 'Run' in the VBA Edit window everything works just fine.

Sub Macro2()
'
' Macro2 Macro
' Macro recorded 3/12/2008 by stub88
'
' Keyboard Shortcut: Ctrl+Shift+G
'
         strVar = MyPath1 + Myname
         Workbooks.Open Filename:=strVar
 
        MsgBox "Hello World"
        
End Sub

Re: Open Workbook From Macro Using Variables

Thanks for the reply, and the code snippet, but that is more or less the code I am trying to exec and it does not work.