Excel 2013 VBA工作簿.打开会丢失调试步骤模式吗? [英] Excel 2013 VBA Workbooks.Open Loses Debug Step Mode?

问题描述

当我进入一个小节然后进入语句时:

When I step into a sub and then step into the statement:

Workbooks.Open Filename:= "C:\file2"

似乎文件打开正常，但是返回时，调用子的其余部分才执行(我进入了模式).能帮上忙吗?

it seems like the file opens okay but on return the remainder of the calling sub just executes (I lose step into mode). Can this be helped?

推荐答案

我曾经遇到过同样的问题，但从未找到理想的解决方案.您可以在打开"命令之后立即在代码行上放置一个断点，或右键单击代码行并选择运行到此处".

I used to have the same problem and never found an ideal fix. You can put a breakpoint on the line of code immediately after the Open command or right-click the line of code and select "run to here".

这篇关于Excel 2013 VBA工作簿.打开会丢失调试步骤模式吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！