Excel 95 equivalent of modern events?

[Auric__]

I recently was given an ancient beast of a laptop with Office 95 installed.
I'm looking into using that as my main "on the road" machine, but there are
some difficulties, and I hope someone here remembers enough about this 19-
year-old version to answer.

1) In my main .xlsm workbook, I have a *lot* of things going on in
Workbook_BeforeSave and Workbook_SheetChange. Is there anything equivalent in
95?

2) Any "gotchas" I need to be aware of, especially re: opening & saving a 95-
formatted workbook in Excel 2007 or 2010? (I already know that Excel removes
all VBA when converting to 95 format.)

 

[GS]

I recently was given an ancient beast of a laptop with Office 95

installed. I'm looking into using that as my main "on the road"
machine, but there are some difficulties, and I hope someone here
remembers enough about this 19- year-old version to answer.

1) In my main .xlsm workbook, I have a *lot* of things going on in
Workbook_BeforeSave and Workbook_SheetChange. Is there anything
equivalent in 95?

2) Any "gotchas" I need to be aware of, especially re: opening &
saving a 95- formatted workbook in Excel 2007 or 2010? (I already
know that Excel removes all VBA when converting to 95 format.)

Sorry but.., this just begs me to ask why not install a newer version?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Auric__]

Sorry but.., this just begs me to ask why not install a newer version?

Believe me, I would *LOVE* to install something newer. Even 97 would be
better than this... but the CD-ROM drive is broken, the machine is so old it
doesn't have USB, I don't own a serial or parallel CD-ROM drive, I can't get
the NIC to work, and I don't have a floppy version of Office newer than
4.something for Win3.x. ;-) (I doubt the disks are even good, anyway.
They've been sitting in a box for something like 15 years now, and probably
hadn't been used for a few years before that.)

Honestly, if I didn't use the hell out of my macros, this wouldn't be that
big of a deal. And really, if it comes down to it, I can do without the
macros, it'll just make more work for me at the end of the day.

 

[GS]

Believe me, I would *LOVE* to install something newer. Even 97 would
be better than this... but the CD-ROM drive is broken, the machine
is so old it doesn't have USB, I don't own a serial or parallel
CD-ROM drive, I can't get the NIC to work, and I don't have a floppy
version of Office newer than 4.something for Win3.x. ;-) (I doubt
the disks are even good, anyway. They've been sitting in a box for
something like 15 years now, and probably hadn't been used for a few
years before that.)

Wow! Glad it's not me wrestling with this!!<g>

FWIW, I had an issue where my MSO2007 disc wouldn't work anymore and so
I bought an e-version I downloaded (for $100 I think), that came with
the 3 standard validations. Would something like this work for you?

http://appscustomerscare.com/browse/category/office-and-business/

Honestly, if I didn't use the hell out of my macros, this wouldn't be
that big of a deal. And really, if it comes down to it, I can do
without the macros, it'll just make more work for me at the end of
the day.

It might be a waste of time if the machine doesn't have the resource
power for your level of usage.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Auric__]

Wow! Glad it's not me wrestling with this!!<g>

What can I say? I like a challenge. ;-)

FWIW, I had an issue where my MSO2007 disc wouldn't work anymore and so
I bought an e-version I downloaded (for $100 I think), that came with
the 3 standard validations. Would something like this work for you?

http://appscustomerscare.com/browse/category/office-and-business/

Hmm... no, I don't think so. Remember, no network access. If I install
anything, it needs to be on floppies. Sigh.

It might be a waste of time if the machine doesn't have the resource
power for your level of usage.

For what I use it for I think it would be just fine. Most of what I do is
simple data entry; the macros just automate large parts of it for me. For
example, when entering city names, rather than having to type everything, I
just enter 1 and a macro changes it to Phoenix, 2->Glendale, 3->Peoria, etc.
Like I said, not strictly necessary, but damn are they useful.

 

[Martin Brown]

I recently was given an ancient beast of a laptop with Office 95 installed.
I'm looking into using that as my main "on the road" machine, but there are
some difficulties, and I hope someone here remembers enough about this 19-
year-old version to answer.

1) In my main .xlsm workbook, I have a *lot* of things going on in
Workbook_BeforeSave and Workbook_SheetChange. Is there anything equivalent in
95?

2) Any "gotchas" I need to be aware of, especially re: opening & saving a 95-
formatted workbook in Excel 2007 or 2010? (I already know that Excel removes
all VBA when converting to 95 format.)

Probably unwise. Its hard disk must be at a high multiple of its MTBF by
now. Even if you get it to work it will likely expire soon after. The
battery life will also be negligible. I no longer support XL95.

Netbooks are highly portable, very cheap now and fairly capable.

Why deliberately set out to wrestle with dinosaurs?

 

[Auric__]

Probably unwise. Its hard disk must be at a high multiple of its MTBF by
now. Even if you get it to work it will likely expire soon after. The
battery life will also be negligible. I no longer support XL95.

Battery life is a non-issue; the laptop will spend the day plugged in. (I
have an ac/dc converter in the car.) Since I spend up to 14 hours a day
driving, it's kind of necessary.

As for the hard drive... I'll worry about that when it happens. (If I could
get the CD drive to work, I could make what amounts to a liveCD containing
Win9x... but a working CD drive would also let me upgrade to Office 97...)

Netbooks are highly portable, very cheap now and fairly capable.

Why deliberately set out to wrestle with dinosaurs?

Because I'm a cheap bastard. ;-)

(Actually, it's because my job suffers a relatively-high incidence of theft
and robbery, and while I wouldn't mind losing my $0 laptop, I *would* mind
losing my $300 netbook.)