Open workbook works on stepping but not on execute

Hi all,

I have a function that loads an excel workbook and steps through its sheets creating a sheet of the same name in the workbook that the macro resides in. When I execute it, it just does nothing aside from load the workbook. When I put the breakpoint on the load line and execute, then single step through the code it works fine. Setting a breakpoint on any line after the load does nothing. This has had me scratching my head for hours. I can't find anything on the web. Where am I going wrong?

Please Login or Register  to view this content.

Any help much appreciated

Marc

It does not even do the debug print and yes it does only have one sheet. As I say works fine if I put a breakpoint on the open and step through from there, but not if I just let the macro run. My thoughts are that the file is not loaded when it gets to the set awb= and hence it gets confused. That does not explain why the msgbox does not appear and the debug print does not print. Maybe it is confused as to which workbook is running the code in some way?

You would not believe the solution!!! I cannot believe I wasted 2 hours on this!!!

http://support.microsoft.com/kb/212074/en-us

don't add a shift in your macro. How the hell that messes up an open, but it does!