Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compatibility with Excel 97 Questions
I am using Excel 2003, but I need to be sure what I write in VBA will run on
a machine with Excel 97. Is there a reference somewhere that talks about how to make your programs compatible with older versions of Excel? Thanks, Ken Loomis |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compatibility with Excel 97 Questions
Ken,
Do you not have an Excel97 machine that you can develop on? It is better than trying to ensure backwards compatibility. -- HTH RP "Ken Loomis" wrote in message ... I am using Excel 2003, but I need to be sure what I write in VBA will run on a machine with Excel 97. Is there a reference somewhere that talks about how to make your programs compatible with older versions of Excel? Thanks, Ken Loomis |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compatibility with Excel 97 Questions
Actually, I don't have a machine with Office 97 on it. I am trying to get a
copy of Excel 97 for that purpose, but this project is actually just a freebie for a friend whose IT department said it couldn't be done. I just laughed when she told me that. I had never programmed in VBA before last weekend when I started on this. With about 20 hours of programming (and lots of help from this newsgroup, thanks for all the help), I have a complete package that combines 4 separate db query results files into one report, complete with lots of editing and formatting. It used to take her two hours to do this by hand and she had to do it once a week. Now it will take her 2 minutes. But now I find out that they only have Excel 97, but why does that surprise me when the IT department said this couldn't be done. There only seems to be a couple of incompatibilities in the arguments for a couple of calls. 'Sort' being one of them I know about for sure. So I was hoping I could find a reference that told about the incompatibilities. Thanks, Ken Loomis "Bob Phillips" wrote in message ... Ken, Do you not have an Excel97 machine that you can develop on? It is better than trying to ensure backwards compatibility. -- HTH RP "Ken Loomis" wrote in message ... I am using Excel 2003, but I need to be sure what I write in VBA will run on a machine with Excel 97. Is there a reference somewhere that talks about how to make your programs compatible with older versions of Excel? Thanks, Ken Loomis |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compatibility with Excel 97 Questions
Ken,
Don't know of a surefire reference, just experience of what it doesn't have, like the Split method. I suppose you want to get it running before moving the XL97 machine? -- HTH RP "Ken Loomis" wrote in message ... Actually, I don't have a machine with Office 97 on it. I am trying to get a copy of Excel 97 for that purpose, but this project is actually just a freebie for a friend whose IT department said it couldn't be done. I just laughed when she told me that. I had never programmed in VBA before last weekend when I started on this. With about 20 hours of programming (and lots of help from this newsgroup, thanks for all the help), I have a complete package that combines 4 separate db query results files into one report, complete with lots of editing and formatting. It used to take her two hours to do this by hand and she had to do it once a week. Now it will take her 2 minutes. But now I find out that they only have Excel 97, but why does that surprise me when the IT department said this couldn't be done. There only seems to be a couple of incompatibilities in the arguments for a couple of calls. 'Sort' being one of them I know about for sure. So I was hoping I could find a reference that told about the incompatibilities. Thanks, Ken Loomis "Bob Phillips" wrote in message ... Ken, Do you not have an Excel97 machine that you can develop on? It is better than trying to ensure backwards compatibility. -- HTH RP "Ken Loomis" wrote in message ... I am using Excel 2003, but I need to be sure what I write in VBA will run on a machine with Excel 97. Is there a reference somewhere that talks about how to make your programs compatible with older versions of Excel? Thanks, Ken Loomis |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compatibility with Excel 97 Questions
I have it running now on an XP box with Excel 2003.
I am pretty sure I have an old copy of office '97 around here somewhere, and an old box with Win 98 on it that I could setup, It's just that I was hoping to have this for her to use tomorrow. And finding where I put that CD is going to be the challenge. I never thought I'd need it again. A workaround is for her to FTP the files and I run it and FTP back the results. So either way it'll happen. Thanks for the comments. Ken Loomis "Bob Phillips" wrote in message ... Ken, Don't know of a surefire reference, just experience of what it doesn't have, like the Split method. I suppose you want to get it running before moving the XL97 machine? -- HTH RP "Ken Loomis" wrote in message ... Actually, I don't have a machine with Office 97 on it. I am trying to get a copy of Excel 97 for that purpose, but this project is actually just a freebie for a friend whose IT department said it couldn't be done. I just laughed when she told me that. I had never programmed in VBA before last weekend when I started on this. With about 20 hours of programming (and lots of help from this newsgroup, thanks for all the help), I have a complete package that combines 4 separate db query results files into one report, complete with lots of editing and formatting. It used to take her two hours to do this by hand and she had to do it once a week. Now it will take her 2 minutes. But now I find out that they only have Excel 97, but why does that surprise me when the IT department said this couldn't be done. There only seems to be a couple of incompatibilities in the arguments for a couple of calls. 'Sort' being one of them I know about for sure. So I was hoping I could find a reference that told about the incompatibilities. Thanks, Ken Loomis "Bob Phillips" wrote in message ... Ken, Do you not have an Excel97 machine that you can develop on? It is better than trying to ensure backwards compatibility. -- HTH RP "Ken Loomis" wrote in message ... I am using Excel 2003, but I need to be sure what I write in VBA will run on a machine with Excel 97. Is there a reference somewhere that talks about how to make your programs compatible with older versions of Excel? Thanks, Ken Loomis |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compatibility with Excel 97 Questions
The type of incompatibilities you speak of are usually caused because
additional options have been added in later versions and would not be recognized by Excel 97. this would usually be where you have recorded the macro. for example, the arguments xl97 recognizes for sort a expression.Sort(Key1, Order1, Key2, Type, Order2, Key3, Order3, Header, OrderCustom, MatchCase, Orientation, SortMethod, IgnoreControlCharacters, IgnoreDiacritics, IgnoreKashida) for Find: expression.Find(What, After, LookIn, LookAt, SearchOrder, SearchDirection, MatchCase, MatchByte) if you are using querytables and recorded the creation of those, you will find problems there. If you try your FTP method, you will work these errors out, one error at a time. She will compile and get the error. Notify you. Fix and start again. -- Regards, Tom Ogilvy "Ken Loomis" wrote in message ... I have it running now on an XP box with Excel 2003. I am pretty sure I have an old copy of office '97 around here somewhere, and an old box with Win 98 on it that I could setup, It's just that I was hoping to have this for her to use tomorrow. And finding where I put that CD is going to be the challenge. I never thought I'd need it again. A workaround is for her to FTP the files and I run it and FTP back the results. So either way it'll happen. Thanks for the comments. Ken Loomis "Bob Phillips" wrote in message ... Ken, Don't know of a surefire reference, just experience of what it doesn't have, like the Split method. I suppose you want to get it running before moving the XL97 machine? -- HTH RP "Ken Loomis" wrote in message ... Actually, I don't have a machine with Office 97 on it. I am trying to get a copy of Excel 97 for that purpose, but this project is actually just a freebie for a friend whose IT department said it couldn't be done. I just laughed when she told me that. I had never programmed in VBA before last weekend when I started on this. With about 20 hours of programming (and lots of help from this newsgroup, thanks for all the help), I have a complete package that combines 4 separate db query results files into one report, complete with lots of editing and formatting. It used to take her two hours to do this by hand and she had to do it once a week. Now it will take her 2 minutes. But now I find out that they only have Excel 97, but why does that surprise me when the IT department said this couldn't be done. There only seems to be a couple of incompatibilities in the arguments for a couple of calls. 'Sort' being one of them I know about for sure. So I was hoping I could find a reference that told about the incompatibilities. Thanks, Ken Loomis "Bob Phillips" wrote in message ... Ken, Do you not have an Excel97 machine that you can develop on? It is better than trying to ensure backwards compatibility. -- HTH RP "Ken Loomis" wrote in message ... I am using Excel 2003, but I need to be sure what I write in VBA will run on a machine with Excel 97. Is there a reference somewhere that talks about how to make your programs compatible with older versions of Excel? Thanks, Ken Loomis |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compatibility with Excel 97 Questions
Hi Ken
I like you "don't accept not possible" approach Don't think you need to install w98 to run xl97, should run on all versions of windows from W95 to XP. BUT I'm pretty sure it's not a good idea to install earlier versions of Excel after later versions (other way round is OK). Regards, Sandy Ken Loomis wrote: I have it running now on an XP box with Excel 2003. I am pretty sure I have an old copy of office '97 around here somewhere, and an old box with Win 98 on it that I could setup, It's just that I was hoping to have this for her to use tomorrow. And finding where I put that CD is going to be the challenge. I never thought I'd need it again. A workaround is for her to FTP the files and I run it and FTP back the results. So either way it'll happen. Thanks for the comments. Ken Loomis "Bob Phillips" wrote in message ... Ken, Don't know of a surefire reference, just experience of what it doesn't have, like the Split method. I suppose you want to get it running before moving the XL97 machine? -- HTH RP "Ken Loomis" wrote in message ... Actually, I don't have a machine with Office 97 on it. I am trying to get a copy of Excel 97 for that purpose, but this project is actually just a freebie for a friend whose IT department said it couldn't be done. I just laughed when she told me that. I had never programmed in VBA before last weekend when I started on this. With about 20 hours of programming (and lots of help from this newsgroup, thanks for all the help), I have a complete package that combines 4 separate db query results files into one report, complete with lots of editing and formatting. It used to take her two hours to do this by hand and she had to do it once a week. Now it will take her 2 minutes. But now I find out that they only have Excel 97, but why does that surprise me when the IT department said this couldn't be done. There only seems to be a couple of incompatibilities in the arguments for a couple of calls. 'Sort' being one of them I know about for sure. So I was hoping I could find a reference that told about the incompatibilities. Thanks, Ken Loomis "Bob Phillips" wrote in message ... Ken, Do you not have an Excel97 machine that you can develop on? It is better than trying to ensure backwards compatibility. -- HTH RP "Ken Loomis" wrote in message .. . I am using Excel 2003, but I need to be sure what I write in VBA will run on a machine with Excel 97. Is there a reference somewhere that talks about how to make your programs compatible with older versions of Excel? Thanks, Ken Loomis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Answers to questions posing more questions in a workbook | Excel Worksheet Functions | |||
View Questions and Answer to questions I created | Excel Discussion (Misc queries) | |||
Testing Reverse Compatibility and Compatibility in General | Excel Discussion (Misc queries) | |||
excel compatibility | Excel Worksheet Functions | |||
Excel 97 compatibility | Excel Worksheet Functions |