Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Versions, File Formats, VBA ... and your job.
Hello,
I want to make sure that whatever code I write in Excel 2002 will work in previous versions of Excel. I know that in Excel 2002, I can save a file doing File/Save As, with the file format in the "Save as type" box as: "Microsoft Excel 97-2002 & 5.0/95 Workbook(*.xls) But even so, this does not mean that if saved under this format, my apps will always work just fine in Excel 97 or 2000. There are perhaps objects, methods, and properties or other VBA elements I have been using in Excel 2002 that will not work in previous versions of Excel. I need to know if that's the case, and the best way to know is to run my apps in Excel 97 and see if there are any problems. Do I have to buy the whole Office 97 suite in order to have Excel '97? How much does Office 97 cost these days? Is it free :) ? Will a retailer be able to order the old product for me? I doubt Microsoft will sell it to me as a download online. I checked the Microsoft website and it does offer service releases downloads, but no old office products, unless I missed them. By the way, let me make your day. Programming jobs are going to ... well you guessed it: India! See msn.com "Will Your Job Move to India?" http://www.msn.com http://moneycentral.msn.com/content/...tra/P62115.asp Thanks. Marc R. Bertrand |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Versions, File Formats, VBA ... and your job.
"Marc R. Bertrand" wrote in message om... Hello, Do I have to buy the whole Office 97 suite in order to have Excel '97? How much does Office 97 cost these days? Is it free :) ? ROTFLMAO Try one of the adverts NG's or ebay Better still, ask a friend to run the project for you. If you install Excel 97 onto your own PC, you may inadvertently use some of the stuff from the later version of Excel, so your test will not be valid. Besides, it screws up the file associations. By the way, let me make your day. Programming jobs are going to ... well you guessed it: India! I suspect that the days of the generalist programmer in the UK/USA are numbered. The route to go is to specialise - either in particular programs to a level the Indians have not got to (yet) or more robustly in a specialist area of work which you know in depth. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Versions, File Formats, VBA ... and your job.
"Marc R. Bertrand" wrote in message om... Hello, I want to make sure that whatever code I write in Excel 2002 will work in previous versions of Excel. I know that in Excel 2002, I can save a file doing File/Save As, with the file format in the "Save as type" box as: "Microsoft Excel 97-2002 & 5.0/95 Workbook(*.xls) But even so, this does not mean that if saved under this format, my apps will always work just fine in Excel 97 or 2000. There are perhaps objects, methods, and properties or other VBA elements I have been using in Excel 2002 that will not work in previous versions of Excel. I need to know if that's the case, and the best way to know is to run my apps in Excel 97 and see if there are any problems. Do I have to buy the whole Office 97 suite in order to have Excel '97? How much does Office 97 cost these days? Is it free :) ? It certainly is not free Will a retailer be able to order the old product for me? I doubt Microsoft will sell it to me as a download online. I checked the Microsoft website and it does offer service releases downloads, but no old office products, unless I missed them. You may be able to find a retailer with unregistered versions I have seen copies at computer fairs and a number of web sites advertise them http://www.tekhwy.com/tek9.asp?pg=products&grp=58 By the way, let me make your day. Programming jobs are going to ... well you guessed it: India! Thats hardly news Keith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to do a UNIX-style diff between two versions of an Excel file | Excel Discussion (Misc queries) | |||
Two versions of same file | Excel Discussion (Misc queries) | |||
File transfers between Excel Versions | Excel Discussion (Misc queries) | |||
2 versions of Excel file opens | Excel Discussion (Misc queries) | |||
How can I verify that an Excel file will work with older versions | Excel Discussion (Misc queries) |