Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Modern day considerations, Integer versus Long | Excel Programming | |||
Is there an Excel equivalent?? | Excel Programming | |||
How to create "modern" controls on a worksheet | Excel Programming | |||
@DSUM (123) equivalent in excel | Excel Programming | |||
Excel equivalent of 'Keep lines together' | Excel Programming |