Excel 2000 App being used in Excel 97, should there be probl

charlie79 · Mar 15th, 2002, 05:59 AM

I have created an Excel Application using VBA, with some ADO code. This app is going to be primarily used on PC's running Excel 97. I have tested it out, and it doesn't seem to want to run any of the code. The macro warning comes up on startup, and I enable them. Is this an issue of writing the app in of backwards compatibility with excel macros?

charlie79 · Mar 15th, 2002, 06:52 AM

I'm really not trying to be pushy, but can't someone please help....

CRWeaks23 · Mar 15th, 2002, 07:00 AM

I dont know the specifics, but I know that I had a TON of problems when I wrote a program in 2000 and tried to use it in 97. To fix the problem, I just copied the whole workbook into an excel 97 workbook and kept stepping through the program, fixing one error at a time.

As a sidenote, if you ever program for others, its always best to program on the LOWEST version that will be used by others, then add things in that only the users of newer versions will be able to use without comprimising the rest of the program.

Regards

charlie79 · Mar 15th, 2002, 07:02 AM

Thanks CR. At least now I know this is a known issue.

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

Mar 15th, 2002, 05:59 AM	#1
charlie79 Board Regular Join Date: Feb 2002 Posts: 97	I have created an Excel Application using VBA, with some ADO code. This app is going to be primarily used on PC's running Excel 97. I have tested it out, and it doesn't seem to want to run any of the code. The macro warning comes up on startup, and I enable them. Is this an issue of writing the app in of backwards compatibility with excel macros?

Mar 15th, 2002, 06:52 AM	#2
charlie79 Board Regular Join Date: Feb 2002 Posts: 97	I'm really not trying to be pushy, but can't someone please help....

Mar 15th, 2002, 07:00 AM	#3
CRWeaks23 New Member Join Date: Mar 2002 Posts: 48	I dont know the specifics, but I know that I had a TON of problems when I wrote a program in 2000 and tried to use it in 97. To fix the problem, I just copied the whole workbook into an excel 97 workbook and kept stepping through the program, fixing one error at a time. As a sidenote, if you ever program for others, its always best to program on the LOWEST version that will be used by others, then add things in that only the users of newer versions will be able to use without comprimising the rest of the program. Regards

Mar 15th, 2002, 07:02 AM	#4
charlie79 Board Regular Join Date: Feb 2002 Posts: 97	Thanks CR. At least now I know this is a known issue.