PDA

View Full Version : Solved: Open vba file



davexpc
04-03-2009, 03:37 PM
Hi there,

I am writing a macro in excel and apparently I have made some sort of mistake in my code. The thing is that when I open my excel file, excel gets stuck as soon as I open it so I can't access the code and modify my last change. Is there any way to access the vba file without opening the excel file? Any way to access my code? If I can't, I'll lose my work!!!

Any help is very much appreciated.

Thanks

David

Bob Phillips
04-03-2009, 03:41 PM
Open it but don't enable macros, put a stop in the first line of Workbook _OPen, save it and re-open, and then step through the code.

davexpc
04-03-2009, 03:48 PM
Thanks xld! I cannot try it now because I don't have the privilege to change security settings in this PC. I'll try again later and will let you know the outcome.

Thanks again,

davexpc

GTO
04-03-2009, 04:44 PM
What version of Excel are you using?

Bob Phillips
04-04-2009, 12:59 AM
I am not suggesting changing any security settings, just use the normal Excel dialog and add a code break.

davexpc
04-06-2009, 03:05 AM
It worked. Thanks guys!