Since being updated to Windows 7 on my laptop, I have been having problems when running a VBA macro in Excel 2003 in debug. Pressing F8 to step forward works ok until I reach any file related operation (e.g. Workbooks.open), after which debug mode is forgotten and the macro continues to end (or fail point!). To overcome this issue I have had to resort to adding breakpoints after every such operation so that I can continue debugging. However, it's a pain having to remember to do so each time, and I shouldn't have to.
Has anyone out there experienced this? Does anyone know how to stop it happening?
Has anyone out there experienced this? Does anyone know how to stop it happening?
Last edited:
