Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba crashing
Can anyone help?
I have developed an Excel worjksheet running a number of macros an functions using VBA. This was complied in Excel 2000 for XP, but whe users using Excel 97 on NT try to open the file it crashes. I thin this is something to do with the VB. Does anyone know how to stop this happening ? I have tried saving m file as Excel 97 but it still happens! All advice gratefully received. Does anyone know about a convertor tha maybe available? Thanks Scott -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba crashing
Excel 97 and xl2000 use the same format. So it is unclear what you mean by
converter - there is no conversion required. Crashes is not very definitive. Do you get a general protection fault? Do you just get an error message - what is it? -- Regards, Tom Ogilvy "scottwilsonx " wrote in message ... Can anyone help? I have developed an Excel worjksheet running a number of macros and functions using VBA. This was complied in Excel 2000 for XP, but when users using Excel 97 on NT try to open the file it crashes. I think this is something to do with the VB. Does anyone know how to stop this happening ? I have tried saving my file as Excel 97 but it still happens! All advice gratefully received. Does anyone know about a convertor that maybe available? Thanks Scott. --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba crashing
It crashes Excel? Powerful coding indeed. Or maybe there is just a macro
error? Could it be that you used an incompatible method or property? It is there a missing reference (Tools, References in the VBE). Unprotect the VB project so you can debug it under Excel 97 and then see what happens. If you want me to try it, send it. I have most Excel versions on my machine, but I am running windows XP. -- Jim Rech Excel MVP "scottwilsonx " wrote in message ... | Can anyone help? | | I have developed an Excel worjksheet running a number of macros and | functions using VBA. This was complied in Excel 2000 for XP, but when | users using Excel 97 on NT try to open the file it crashes. I think | this is something to do with the VB. | | Does anyone know how to stop this happening ? I have tried saving my | file as Excel 97 but it still happens! | | All advice gratefully received. Does anyone know about a convertor that | maybe available? | | Thanks | Scott. | | | --- | Message posted from http://www.ExcelForum.com/ | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel crashing | Excel Discussion (Misc queries) | |||
Is this crashing for you ? | Excel Programming | |||
How to keep excel from crashing? | Excel Programming | |||
excel keeps crashing | Excel Programming | |||
Toolbars and Crashing | Excel Programming |