Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel function macros
Over the years, I've developed a sizeable set of Excel function macros
to perform a variety of engineering calculations. These macros were developed using Excel v. 4.0 macro language. I'm using MS Office X on a Mac G3 powerbook. As recently as a few months ago I was able to modify the source spreadsheet/macrosheet file and create updated add-in files for the macros. However, I've tried doing this again today and cannot save the modifed macro sheet as a valid add-in file. It's possible I'm missing or forgetting something...or perhaps Microsoft has issued an update which has completely removed this fuctionality. Any advice on how to create Excel 4 function macros under Excel Office X is much appreciated. There's little incentive for me to reprogram the macros in VBA....or whatever is now used for programming function macros these days. Thanks for your help. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel function macros
Thanks for the quick....and encouraging.....reply.
Upon opening a new BLANK workbook, the "save as" dialogue box provides ability to save file as an Excel Add-in file. So far, so good. However, once I've pasted the updated macros into a macrosheet in that workbook, the "Save as Add-in file" option disappears from the file format list. I can manually add a ".xla" suffix to the filename, but it does not create a vadid add-in. Same things happens with Excel 98, so maybe I'm doing something wrong. Thanks, Tom *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel function macros
When I tested it in XLv.X - the add-in type was not available if the
macro sheet was active, but it was available if a worksheet was active. In article , Tom McGuinness wrote: Upon opening a new BLANK workbook, the "save as" dialogue box provides ability to save file as an Excel Add-in file. So far, so good. However, once I've pasted the updated macros into a macrosheet in that workbook, the "Save as Add-in file" option disappears from the file format list. I can manually add a ".xla" suffix to the filename, but it does not create a vadid add-in. Same things happens with Excel 98, so maybe I'm doing something wrong. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel function macros
JE, Eureka! Problem solved. You're an ace. Many thanks. Tom *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Protect Function, while allowing macros | Excel Worksheet Functions | |||
Help with Excel if function and macros | Excel Worksheet Functions | |||
Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions | |||
Making excel macros run Word macros | Excel Programming | |||
Calling Excel FUNCTION MACROS Programmatically from VB | Excel Programming |