Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 538
Default Excel 95 equivalent of modern events?

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 opening & saving a 95-
formatted workbook in Excel 2007 or 2010? (I already know that Excel removes
all VBA when converting to 95 format.)

--
The large print giveth, and the small print taketh away.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,514
Default Excel 95 equivalent of modern events?

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 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



---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 538
Default Excel 95 equivalent of modern events?

GS wrote:

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 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?


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.

--
Giggling bushes? That's not something you hear every day.
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,514
Default Excel 95 equivalent of modern events?

GS wrote:

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 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?


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/...-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



---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 538
Default Excel 95 equivalent of modern events?

GS wrote:

GS wrote:

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 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?


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


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/...-and-business/


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

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.


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.

--
There are things that can't be seen or heard or felt or smelled or tasted...
but for most everyday activities, our senses are sufficient.


  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 230
Default Excel 95 equivalent of modern events?

On 05/02/2014 08:12, Auric__ wrote:
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 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?

--
Regards,
Martin Brown
  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 538
Default Excel 95 equivalent of modern events?

Martin Brown wrote:

On 05/02/2014 08:12, Auric__ wrote:
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 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.


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 *******. ;-)

(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.)

--
Any warrior can take lives,
but a truly great warrior struggles to save them.
-- Czar of Sea
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
Modern day considerations, Integer versus Long Neal Zimm Excel Programming 7 February 13th 10 11:46 PM
Is there an Excel equivalent?? Howard Kaikow Excel Programming 4 April 14th 08 05:56 PM
How to create "modern" controls on a worksheet Josh Sale Excel Programming 12 August 22nd 07 04:12 PM
@DSUM (123) equivalent in excel jdelayknee[_2_] Excel Programming 1 July 24th 06 11:00 AM
Excel equivalent of 'Keep lines together' Fred Smith Excel Programming 2 July 8th 04 03:57 AM


All times are GMT +1. The time now is 01:02 AM.

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"