Any Microsoft Excell Gurus here?

[caryc]

Back when I was working, I developed a set of Excel files set up with macros that did some incredible things that saved the sales personnel a lot of time processing orders.

I found an "A" drive disc with that set of files on it. I wanted to view the files and try them out again but "Excel" would load the files but not run the macros that went with them. It said something about them not being digitally signed or verified as safe.

I created them way back in Windows 98. Anybody know how I can get Excel to run these macros? I know they are safe since I created them.

 

[TBear77]

Cary,

The Windows version isn't the issue here, it's the Excel version. There's versions 97, 2000, and XP that could be run on Windows 98.

The way I recovered files from previous versions is to download a copy of Open Office Calc, then open a copy of your original file. Most, if not all, the macros should convert. But depending on your previous Excel version, it may convert the macros to values or gibberish error messages. If the files do convert, then use the Save-As function to save the files to a newer Excel format.

There may be a way to override the security features and run the macros, but I have migrated away from Microsoft programs...especially Excel.

Ted

 

[Pat-inCO]

Sounds like this may help.
https://support.office.com/en-us/ar...in-Excel-a97c09d2-c082-46b8-b19f-e8621e8fe373

 

[caryc]

Thanks guys. I got my macros to run.

Here's an example of a tuff one to figure out for me. This was in a spread sheet with formulas in nine other cells. The one in column M really racked my brain to figure out.

The first four columns are entered by the office people then you hit Control+M and the macro supplied the info in the remaining columns. Since we made all the siding for trailers and recreational motor homes, everything we sold was priced by the pound. That included the offall. Say your ordered a 43" wide piece, that was cut out of a 48" piece so you paid for the whole piece. But say you wanted those 43" pieces designed with the designs you see on all the sides of fifth wheels and motor homes, you would then pay more for the 43" pieces than that left over 5" piece. It gets kind of complicated but that's the best I can explain it. Anyway, that's why they needed all that extra info. All our different coils of metal were priced by the weight of one square foot of the material and we had material of different thicknesses.

If you look at the bottom of the pic, you'll see that there are 7 other pages in this file that do different things.

 

[Rick Courtright]

Hi,

Glad you got things going, Cary. However, I'd still second Ted's suggestion to look at Open Office Calc. It's part of an entire office suite from Apache.com available here:

https://www.openoffice.org/download/?utm_source=AOO4_1_3_en-US&utm_medium=Client&utm_campaign=Upgrade

Open Office was recommended to me several years ago by a fellow who'd suffered the same complaint I had: I got tired of never having the "right" version of Excel on my machine (despite there being several!), to read Excel spreadsheets clients sent me. Open Office will not only read every version of Excel I've tried, but will save from its native .ods format (which sounds like a fairly universal format) to pretty much every variant and aberration of Excel MS has sent down the pike so far so my guys can read work I send them in their own Excel programs.

And you'll like the price: it's FREE!

Now, nothing's perfect. If you have a computer that's a few years old and isn't up to today's horsepower standards, it may take a short while to load the program once it's installed. Best I can tell, the entire suite loads, as opposed to being able to load Excel by itself back when. But that's a very minor price to pay in my book.

Rick C

 

[caryc]

Hi,

Glad you got things going, Cary. However, I'd still second Ted's suggestion to look at Open Office Calc. It's part of an entire office suite from Apache.com available here:

https://www.openoffice.org/download/?utm_source=AOO4_1_3_en-US&utm_medium=Client&utm_campaign=Upgrade

Open Office was recommended to me several years ago by a fellow who'd suffered the same complaint I had: I got tired of never having the "right" version of Excel on my machine (despite there being several!), to read Excel spreadsheets clients sent me. Open Office will not only read every version of Excel I've tried, but will save from its native .ods format (which sounds like a fairly universal format) to pretty much every variant and aberration of Excel MS has sent down the pike so far so my guys can read work I send them in their own Excel programs.

And you'll like the price: it's FREE!

Now, nothing's perfect. If you have a computer that's a few years old and isn't up to today's horsepower standards, it may take a short while to load the program once it's installed. Best I can tell, the entire suite loads, as opposed to being able to load Excel by itself back when. But that's a very minor price to pay in my book.

Rick C

Rick,

I downloaded Open Office Calc. It opened my Excel file but I could not get it to run the macros even when changing the macro security level to the lowest setting.

Changing it to the lowest setting in Excel is how I got Excel to run my macros.