Visual Studio Just-In Time Debugger

**jo15765** · 02-07-2012, 05:41 PM

I am running some VBA code, and today, I just started having Excel crash on me and getting a message that says
Visual Studio Just-In Time Debugger
An unhandled win32 exception occurred in EXCEL.EXE[4140]

What is causing this, and/or what can I do that will prevent this from happening and my code execute?

**OnErrorGoto0** · 02-07-2012, 07:07 PM

Impossible to say specifically from that information. Do you have Visual Studio installed?

**jo15765** · 02-07-2012, 07:24 PM

Yes visual studio is installed on the machine that produces this error.

**OnErrorGoto0** · 02-08-2012, 05:08 AM

I suspect there is a setting in VS to debug app crashes. Can't say why your code might be causing the app crash though.

**jo15765** · 02-08-2012, 11:13 AM

I stepped through the code, and I found it is producing this error when it is trying to copy open a workbook that doesn't exist. Makes sense as to why it would only sporadically produce the error because sometimes the workbook is there whereas others it's not

**OnErrorGoto0** · 02-08-2012, 11:29 AM

Your code really ought to check that before it tries to do anything with the workbook! As an example

Please Login or Register  to view this content.

**jo15765** · 02-08-2012, 11:35 AM

I agree, it needs to! The problem I was running into was the location of the workbooks was constantly changing and since the code is still in the "Testing" phase I never took into account the workbook not existing.

The problem that I have with checking if the workbook exists is that the Base of the path will be the same, but the workbook could be in one of seven sub-folders that is created by the VBA.

Please Login or Register  to view this content.

So in that location there would be subfolders and the workbook it is checking for would be in one of the subfolders. I am trying code a function that would be able to check each sub-folder for the workbook as opposed to having to manually write the code for all 8 workbooks.