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.
Open Workbook From Macro Using Variables
-
-
-
Re: Workbooks.open In Macro Code
As long as you are setting mypath1 correct and my name this should work:
-
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.
-
Re: Open Workbook From Macro Using Variables
Are you sure it's not the keyboard shortcut that isn't working rather than the code?
-
Re: Open Workbook From Macro Using Variables
My thinking too norie as i tried the code in xl2000, xl2003, xl2007 and it worked perfect!
-
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!