Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert XL2K wkbk w/ macros to XL97?
I've got a customer who still has XL97. As such, he can't open my workbook,
created in XL2000 and stuffed full of macros for searching, etc. I pasted the front page data only into a new workbook and saved as XL97/2000, and he opened it fine. But there were no macros in it, either. Is there an easy way to convert this so he has full functionality? Ed |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert XL2K wkbk w/ macros to XL97?
Hi Ed,
For the most part, Excel 97 and 2000 are compatible with each other but, if you construct a workbook using features that weren't available in Excel 97, they won't work properly. Except for things that are macro-related, the workbook should still open, though. If you're using an Excel 2000 Auto_open macro, or macros fired by calculation or activation events on the opening worksheet, they could stop the workbook in its tracks if the macro uses code not supported in Excel 97. Cheers "Ed" wrote in message ... I've got a customer who still has XL97. As such, he can't open my workbook, created in XL2000 and stuffed full of macros for searching, etc. I pasted the front page data only into a new workbook and saved as XL97/2000, and he opened it fine. But there were no macros in it, either. Is there an easy way to convert this so he has full functionality? Ed --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.580 / Virus Database: 367 - Release Date: 6/02/2004 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I best "scrub" a wkbk of "phantom macros"? | Excel Discussion (Misc queries) | |||
Does XL2K have hard hyphens? | Excel Discussion (Misc queries) | |||
Copying autoshapes - XL2K | Excel Discussion (Misc queries) | |||
Problems with xl97 & xl2K | Excel Programming | |||
Open XL2K without executing Macros | Excel Programming |