I have created a template designed for order-entry, I have made numberous
enhancements to it. Unfortunately, now when adding the latest code to it it
crashes on open every time. I have a backup but it does not have the latest
code i added. It is not the code that cause a crash because even with macros
disabled on opened it will crash excel, EVERY SINGLE TIME this is any machine
i have run it on under different circumstances. My question, is there a way
to extract your VBA project without opening the .XLT file?. all modules and
objects, etc......

please help!!!

Hi Ben;

The pure answers is no. However, you might try some work
arounds such as:

Use code to open it programatically and tell it not to use
any auto open macros and to open it read only.

Use Lotus Notes to open it.

If it has auto open macros you can press Ctrl / Pause
Break while it is opening to stop the process.

Good Luck!

Greg




-----Original Message-----
I have created a template designed for order-entry, I
have made numberous
enhancements to it. Unfortunately, now when adding the
latest code to it it
crashes on open every time. I have a backup but it does
not have the latest
code i added. It is not the code that cause a crash
because even with macros
disabled on opened it will crash excel, EVERY SINGLE TIME
this is any machine
i have run it on under different circumstances. My
question, is there a way
to extract your VBA project without opening the .XLT
file?. all modules and
objects, etc......

please help!!!

.

unfortunately no,
the problem is not with the macros, it is with the worksheet,
I can open it with macros disabled, in everyway i can think of, pausing VBA,
ctrl+Open etc... and it still crashes


"GJones" wrote:

Hi Ben;

The pure answers is no. However, you might try some work
arounds such as:

Use code to open it programatically and tell it not to use
any auto open macros and to open it read only.

Use Lotus Notes to open it.

If it has auto open macros you can press Ctrl / Pause
Break while it is opening to stop the process.

Good Luck!

Greg




-----Original Message-----
I have created a template designed for order-entry, I
have made numberous
enhancements to it. Unfortunately, now when adding the
latest code to it it
crashes on open every time. I have a backup but it does
not have the latest
code i added. It is not the code that cause a crash
because even with macros
disabled on opened it will crash excel, EVERY SINGLE TIME
this is any machine
i have run it on under different circumstances. My
question, is there a way
to extract your VBA project without opening the .XLT
file?. all modules and
objects, etc......

please help!!!

.