Excel 2010 Macro mysteriously stops running after command Workbooks.Open("WorkbookFullName")
Posted on 2013-10-02
Before I break down a workbook to send over....
Has anyone come across this odd phenomenon?
The Workbooks.Open ("Name") command opens and activates the named file.
At this point the macro just stops running.
The next command is to activate a specific sheet within the open workbook.
I have tried debugging the code. It runs perfectly when run line by line.
I have tried transferring the command to a new sub routine and calling it from the original routine, to no avail.
is this a recognised phenomenon for excel VBA? I have tried searching, without much illumination.