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

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.

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