Problem Single-Stepping Through workbooks.open

**StevenHB** · 01-11-2012, 03:28 PM

I'm running Excel 2010 32 bit (on 64-bit Windows 7) and am experiencing some odd behavior in VBA with the debugger. When I try to single step through the following line of code:

Set OpenExternalWorkbook = Workbooks.Open(Filename:=strWorkbookName, ReadOnly:=ReadOnly)

the workbook identified by strWorkbookName is opened briefly and then closes. Execution of the calling function is halted. If I run through this line of code, even if the very next line of code is a "stop" command, everything runs just fine. Has anyone seen behavior like this before?

Just to be clear, there are no autorun event handlers in strWorkbookName.

Any help would be greatly appreciated.

**JapanDave** · 01-11-2012, 05:34 PM

I have had the same issues with the debugger. The way I get around this is to use the breakpoints tool, then debug anywhere after any code that calls for another workbook.

**StevenHB** · 01-11-2012, 06:39 PM

Well, I'm glad to learn that I'm not crazy. It sure seemed weird.

I had slightly different, but equally bizarre behavior in another workbook. In this other workbook, when I single-stepped through the workbooks.open command, it ran the entire macro without stopping, even though it should have stopped at the next line of code.