Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 70
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 170
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to do a UNIX-style diff between two versions of an Excel file Kilongen Excel Discussion (Misc queries) 3 August 10th 09 05:31 PM
Two versions of same file Richard Champlin Excel Discussion (Misc queries) 3 May 18th 09 06:29 PM
File transfers between Excel Versions Tail Wind Excel Discussion (Misc queries) 3 December 15th 07 07:39 PM
2 versions of Excel file opens ddate Excel Discussion (Misc queries) 1 September 21st 06 02:58 AM
How can I verify that an Excel file will work with older versions Tony English Excel Discussion (Misc queries) 3 January 30th 06 02:57 PM


All times are GMT +1. The time now is 01:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"