ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2003 code, problem in Excel 97 (https://www.excelbanter.com/excel-discussion-misc-queries/101437-excel-2003-code-problem-excel-97-a.html)

brianbishop

Excel 2003 code, problem in Excel 97
 

Hi

I have written some VBA code for a Macro in Excel 2003, was working on
it for weeks. I sent it to a colleague who uses Excel 97/2000 and it
gave errors for the macro code.

Is there a way I can save my Excel 2003 file/code so it opens ok with
previous versions of Excel?

Regards

Brian Bishop
Ireland


--
brianbishop
------------------------------------------------------------------------
brianbishop's Profile: http://www.excelforum.com/member.php...o&userid=36811
View this thread: http://www.excelforum.com/showthread...hreadid=565196


Don Guillett

Excel 2003 code, problem in Excel 97
 
Versions are almost always upward compatible but not backward compatible.
For some clients I sometimes have to write programs using xl95. If you have
97, do it there. If not, If you post your code here someone will try to
help.

--
Don Guillett
SalesAid Software

"brianbishop"
wrote in message
...

Hi

I have written some VBA code for a Macro in Excel 2003, was working on
it for weeks. I sent it to a colleague who uses Excel 97/2000 and it
gave errors for the macro code.

Is there a way I can save my Excel 2003 file/code so it opens ok with
previous versions of Excel?

Regards

Brian Bishop
Ireland


--
brianbishop
------------------------------------------------------------------------
brianbishop's Profile:
http://www.excelforum.com/member.php...o&userid=36811
View this thread: http://www.excelforum.com/showthread...hreadid=565196





All times are GMT +1. The time now is 08:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com