If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Add-in Macros
My boss and I need to share a spreadsheet which uses a macro that is
defined in an addin. He is running windows xp with excel 97 and I'm running OS X 10.3.9 with excel 2004. When I first tried to use the spreadsheet I got these errors saying excel couldn't find macro. I determined the problem was for some reason the path to the addin was in the formula and excel thought the macro name was a range. I was able to use the macro and the spread by using find and replace to remove the path from all the formulas which used the macro. All was well and good until earlier today my boss made some change to the worksheet and now all the addin paths are showing up again. I have not asked him if he had any trouble using the macro from the addin after I had saved it previously. Obviously I can always do a find and replace on the add-in paths whenever I open up the file, but that is really annoying and I have to use the spreadsheet 2 to 3 times a week. So after all that backstory here is my question: 1. Are the lack of complete paths to the add-in causing trouble for my boss? 2. Is there anyway to get excel on mac to realize the file path points to the add-in which it already has installed? Your help is greatly appreciated. -RT |
#2
|
|||
|
|||
Add-in Macros
Did you properly install the addin, ToolsAddins and browse to find it, not
just load it like any other spreadsheet? -- HTH Bob Phillips (remove nothere from the email address if mailing direct) wrote in message ups.com... My boss and I need to share a spreadsheet which uses a macro that is defined in an addin. He is running windows xp with excel 97 and I'm running OS X 10.3.9 with excel 2004. When I first tried to use the spreadsheet I got these errors saying excel couldn't find macro. I determined the problem was for some reason the path to the addin was in the formula and excel thought the macro name was a range. I was able to use the macro and the spread by using find and replace to remove the path from all the formulas which used the macro. All was well and good until earlier today my boss made some change to the worksheet and now all the addin paths are showing up again. I have not asked him if he had any trouble using the macro from the addin after I had saved it previously. Obviously I can always do a find and replace on the add-in paths whenever I open up the file, but that is really annoying and I have to use the spreadsheet 2 to 3 times a week. So after all that backstory here is my question: 1. Are the lack of complete paths to the add-in causing trouble for my boss? 2. Is there anyway to get excel on mac to realize the file path points to the add-in which it already has installed? Your help is greatly appreciated. -RT |
#3
|
|||
|
|||
Add-in Macros
Yes, I installed the add-ins correctly.
|
#4
|
|||
|
|||
Add-in Macros
I have been able to answer question (1). The answer is no. I had
removed the file path to the same excel add-in in another spreadsheet. I later opened that spreadsheet up in windows and I didn't notice any problem. After saving the spreadsheet in windows I now have all the add-in file paths back in my spreadsheet. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
making macro available to other presentations and deleting macros | xppuser | Powerpoint | 14 | February 9th, 2006 03:19 PM |
Bug: Editing digitally signed templates with macros | EZStrobe | Visio | 0 | September 17th, 2005 06:19 PM |
Macros run inconsistently: run in old records or copies of old rec | HBrock | New Users | 1 | February 9th, 2005 11:48 AM |
Passing documents with macros and toolbar icons for the macros | SteveK | Powerpoint | 1 | February 7th, 2005 07:24 PM |
Using macros on custom toolbars in templates. | Conan Kelly | Worksheet Functions | 2 | August 2nd, 2004 02:28 PM |