Excel v4 spreadsheet not working on new versions.

Feb 20th, 2002, 05:44 PM

I have a very useful program that was written in Excel v4. I have tried to get it working in Excel v2000 - v5. It has plenty of the old XLM macro's that don't seem to work in the newer versions of Excel and the program stops working when it gets to crosstabs etc.

What are my options for getting this working, is there a way of getting hold of excel v4 (I have the correct licenses) or is there a lite version that can run the program without editing it. Can the macros be edited or converted to work on a more recent version?? Help please!!!

anno · Feb 20th, 2002, 11:20 PM

i think getting hold of xl4 is your best shot - i tried to convert some xl4 macros to vba by turning on the vba macro recorder and running the xl4 macros but the recorder thought it was an application running and i only got about 2 lines of useless code out of it. we relied on them fairly heavily and there was much pulling of hair when we upgraded to excel 5 (it was supposed to run xl4 macros but never did properly) and we never found a way to get around it so had to stick with xl4 for those functions. that was a while ago though. sorry i can't be of any help, but i do know how you feel. good luck

Bruno · Feb 21st, 2002, 08:53 AM

All my XL4 macro's are working in Excel 97...
XL2000 is not installed on my PC

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 20th, 2002, 05:44 PM	#1
Guest Posts: n/a	I have a very useful program that was written in Excel v4. I have tried to get it working in Excel v2000 - v5. It has plenty of the old XLM macro's that don't seem to work in the newer versions of Excel and the program stops working when it gets to crosstabs etc. What are my options for getting this working, is there a way of getting hold of excel v4 (I have the correct licenses) or is there a lite version that can run the program without editing it. Can the macros be edited or converted to work on a more recent version?? Help please!!!

Feb 20th, 2002, 11:20 PM	#2
anno Board Regular Join Date: Feb 2002 Posts: 202	i think getting hold of xl4 is your best shot - i tried to convert some xl4 macros to vba by turning on the vba macro recorder and running the xl4 macros but the recorder thought it was an application running and i only got about 2 lines of useless code out of it. we relied on them fairly heavily and there was much pulling of hair when we upgraded to excel 5 (it was supposed to run xl4 macros but never did properly) and we never found a way to get around it so had to stick with xl4 for those functions. that was a while ago though. sorry i can't be of any help, but i do know how you feel. good luck

Feb 21st, 2002, 08:53 AM	#3
Bruno Board Regular Join Date: Feb 2002 Posts: 468	All my XL4 macro's are working in Excel 97... XL2000 is not installed on my PC