Excel 2000 and Excel 2002

shades · May 13th, 2002, 02:51 PM

Up until last Friday I had been using Excel 97 with Windows 95. I had been waiting for over a year for an upgrade, and was told almost a year ago that it would be Office 2000 with Windows 2000. So I knew we were getting close, and two weeks ago I ordered two books:

"MS Excel 2000 Formulas" (Walkenbach)
"MS Excel 2000 VBA Fundamentals" (Jacobson)

The company upgraded last week to Windows 2000. But - it is Office 2002!

My question: How much am I missing by using these two brand new books that are no longer approrpiate to the non-existent upgrade that I wasn't supposed to get?

Should I just use them, or should I give them to a library and order the 2002 versions?

stevebausch · May 13th, 2002, 03:42 PM

I wouldn't lose any sleep over differences between 2000 and 2002. Make your code obedient to the error messages you will receive when you run your Excel 97 code in Excel 2002, and be done with it.

Read the Help files for "What's New". Check out what Microsoft says is improved. Chances are your error mesages (or lack thereof) will actually drive your Excel 2002 coding attempts.

NateO · May 13th, 2002, 05:32 PM

Your learnings from the xl2000 literature should be applicable in xl2002, you just won't have all of the functionaility depicted in your readings like:

http://msdn.microsoft.com/library/de...xlmthSpeak.asp

But the site above is searchable and perhaps you can save some $$ by searching that reference to fill some smaller gaps. John W. was underwhelmed by 2002 in a small review I read...

_________________
Cheers, NateO

[ This Message was edited by: NateO on 2002-05-13 16:35 ]

shades · May 14th, 2002, 09:20 AM

Thanks, guys. I feel better about just keeping the books and catching the 2002 features as I go.

Jack in the UK · May 14th, 2002, 01:15 PM

Hi Shades

I have cupboards of books, im looking at Version 4 Excel i bough in 1994 the function reference! and FTP2000, HTML Help, JavaScript VB help 1995, even word 97OEM manual from when I worked in software distribution, getting results from Office 95 this is from my present from Canada for techi support i gave a child’s charity kids on drugs and abused, just showing the kids life fun.. very close to me that manual as are the 44 floppy disks, i often cart that about, out of date but reference is god..

I sit answering reading XP MCSE as i try to get my MCP up to date.. i have many books all i grab to get techi info as I work, how ever all i post is me LIVE as i feel the question needs answering.

KEEP them thay are work horses and will come in extremely handy.

This i am often asked how why do i know that A works with B, this is the reason i read most days and re read the same... old or new... all knowledge will help..

the difference between 97 200 and XP is power with what calculation and more help and functions in tandem with more VBA ...

all in all its an expansion.

as a rule going UP versions is cool and few bit bug but going down is different

my advice.. keep reading, playing and learn as you want to, most of all have fun and enjoy it.

remember to use official patch’s and keep the office up to date.

take care and good luck

May 13th, 2002, 02:51 PM	#1
shades Board Regular Join Date: Mar 2002 Location: Near the Land of Oz Posts: 1,550	Up until last Friday I had been using Excel 97 with Windows 95. I had been waiting for over a year for an upgrade, and was told almost a year ago that it would be Office 2000 with Windows 2000. So I knew we were getting close, and two weeks ago I ordered two books: "MS Excel 2000 Formulas" (Walkenbach) "MS Excel 2000 VBA Fundamentals" (Jacobson) The company upgraded last week to Windows 2000. But - it is Office 2002! My question: How much am I missing by using these two brand new books that are no longer approrpiate to the non-existent upgrade that I wasn't supposed to get? Should I just use them, or should I give them to a library and order the 2002 versions? __________________ - old, slow, and confused ... but at least I'm inconsistent - (retired Excel 2003 user, 3.28.2008)

May 14th, 2002, 09:20 AM	#4
shades Board Regular Join Date: Mar 2002 Location: Near the Land of Oz Posts: 1,550	Thanks, guys. I feel better about just keeping the books and catching the 2002 features as I go. __________________ - old, slow, and confused ... but at least I'm inconsistent - (retired Excel 2003 user, 3.28.2008)

May 14th, 2002, 01:15 PM	#5
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	Hi Shades I have cupboards of books, im looking at Version 4 Excel i bough in 1994 the function reference! and FTP2000, HTML Help, JavaScript VB help 1995, even word 97OEM manual from when I worked in software distribution, getting results from Office 95 this is from my present from Canada for techi support i gave a child’s charity kids on drugs and abused, just showing the kids life fun.. very close to me that manual as are the 44 floppy disks, i often cart that about, out of date but reference is god.. I sit answering reading XP MCSE as i try to get my MCP up to date.. i have many books all i grab to get techi info as I work, how ever all i post is me LIVE as i feel the question needs answering. KEEP them thay are work horses and will come in extremely handy. This i am often asked how why do i know that A works with B, this is the reason i read most days and re read the same... old or new... all knowledge will help.. the difference between 97 200 and XP is power with what calculation and more help and functions in tandem with more VBA ... all in all its an expansion. as a rule going UP versions is cool and few bit bug but going down is different my advice.. keep reading, playing and learn as you want to, most of all have fun and enjoy it. remember to use official patch’s and keep the office up to date. take care and good luck __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

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

May 13th, 2002, 03:42 PM	#2
stevebausch Board Regular Join Date: May 2002 Posts: 809	I wouldn't lose any sleep over differences between 2000 and 2002. Make your code obedient to the error messages you will receive when you run your Excel 97 code in Excel 2002, and be done with it. Read the Help files for "What's New". Check out what Microsoft says is improved. Chances are your error mesages (or lack thereof) will actually drive your Excel 2002 coding attempts.

May 13th, 2002, 05:32 PM	#3
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	Your learnings from the xl2000 literature should be applicable in xl2002, you just won't have all of the functionaility depicted in your readings like: http://msdn.microsoft.com/library/de...xlmthSpeak.asp But the site above is searchable and perhaps you can save some $$ by searching that reference to fill some smaller gaps. John W. was underwhelmed by 2002 in a small review I read... _________________ Cheers, NateO [ This Message was edited by: NateO on 2002-05-13 16:35 ]