Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Any known issues between VBA for Excel 2000 & 2003
I have developed an application in Excel 2000 (SP3) for a colleague using
2003. The main bulk of the application is moving data around, although there is some charting. When my colleague tries to open the workbook he gets the usual secuirty warning about opening the book with the macros in and then gets an error message saying that Excel has encountered a problem and has to close. If you reopen it Excel tries to 'repair' the problem by removing the VBA. Is this a compatibility issue? Thanks, Ben |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Any known issues between VBA for Excel 2000 & 2003
Ben
It shouldn't be. If you were going the other way, there could be some compatibility issues, but developing in a lower version should cause no problems at all. The first thing I would try is (from 2000) to export all the modules, delete them, then reimport them. Then recompile and Save. Send that over to him and see if there's something in the code that's screwing it up. If that doesn't work, you might try round-tripping the workbook through HTML. Save it as HTML, the open the HTML and save back as an Excel Workbook. If there's some corruption in the workbook, that may get rid of it. -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "Ben P" <Ben wrote in message ... I have developed an application in Excel 2000 (SP3) for a colleague using 2003. The main bulk of the application is moving data around, although there is some charting. When my colleague tries to open the workbook he gets the usual secuirty warning about opening the book with the macros in and then gets an error message saying that Excel has encountered a problem and has to close. If you reopen it Excel tries to 'repair' the problem by removing the VBA. Is this a compatibility issue? Thanks, Ben |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Any known issues between VBA for Excel 2000 & 2003
Just to add to Dick's response...
Rob Bovey has a utility that does the export/import for you (cleaning up the code). You can find it at: http://www.appspro.com/ And if that doesn't help: You may want to try OpenOffice. If the file is corrupted, OpenOffice may be able to open it. http://www.openoffice.org, a 60-65 meg download or a CD And if the file is corrupted and is really important, there are commercial recovery services. I've never used it, but you might want to check into: http://www.officerecovery.com Ben P wrote: I have developed an application in Excel 2000 (SP3) for a colleague using 2003. The main bulk of the application is moving data around, although there is some charting. When my colleague tries to open the workbook he gets the usual secuirty warning about opening the book with the macros in and then gets an error message saying that Excel has encountered a problem and has to close. If you reopen it Excel tries to 'repair' the problem by removing the VBA. Is this a compatibility issue? Thanks, Ben -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 with 2003 issues | Excel Discussion (Misc queries) | |||
CSV issues Excel 2003 | Excel Discussion (Misc queries) | |||
2003 to 2000 CSV compatiblity issues | Excel Discussion (Misc queries) | |||
Compatibility issues with macros (2000 vs. 2003)? | Excel Discussion (Misc queries) | |||
excel 2000 add-in causing delay issues | Excel Programming |