Can't load a file because of a bad macro

[Peter John Soutter City 18301]

I think I've cerated a loop in a macro that runs when I try to open a
certain file. I can open it if I disable the macros, so I think I've
stuffed up one of my macros. Is there a way to get into a file from
another way. I've probably got 12 hours work locked into this file.
Any help will be appreciated . Regards PJS

 

[Andy Pope]

Hi,

Why do you need another way?
Open without enabling macros. Goto VBE and comment out suspect code.
Then save and re open.

If you have code in the workbook open event you can disables events whilst
opening the file.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
message
news:0687ee30-e08a-478a-8181-97f4066e8e9a@v16g2000prc.googlegroups.com...

 

[Peter John Soutter City 18301]

Hi,

Why do you need another way?
Open without enabling macros. Goto VBE and comment out suspect code.
Then save and re open.

If you have code in the workbook open event you can disables events whilst
opening the file.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excelhttp://www.andypope.info
message



- Show quoted text -

Andy
Thanks a million, I had 2 macros with the same name,
I've learn't a hell of a lot since you last answered a question of
mine, but I still know nothing.
The forun has changed a lot since I was here last.
Do I owe you any money and if so how much ?
Regards and thanks again Peter Soutter

 

[Andy Pope]

Hi Peter,

I answered your post via the public newsgroups so no charge.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
message

Hi,

Why do you need another way?
Open without enabling macros. Goto VBE and comment out suspect code.
Then save and re open.

If you have code in the workbook open event you can disables events whilst
opening the file.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excelhttp://www.andypope.info
message



- Show quoted text -

Andy
Thanks a million, I had 2 macros with the same name,
I've learn't a hell of a lot since you last answered a question of
mine, but I still know nothing.
The forun has changed a lot since I was here last.
Do I owe you any money and if so how much ?
Regards and thanks again Peter Soutter