Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA AddIn reference in Excel X for Mac
I have installed the Analysis Toolpak and Analysis Toolpak - VBA on my Power
PC G4 using Excel X for Mac. I have included one of the addin functions in a macro that starts upon opening of the workbook. Before I put the addin in my code, I had no problems with the macro starting when the workbook was opened. Once I put that in, Excel hangs and crashes upon opening the workbook. I added AddIns("Analysis Toolpak - VBA").Installed = True to the open event, but the workbook still crashed. Either way, Excel isn't recognizing the AddIn properly until I close the macro and restart it. It seems to work ok if I don't start the macro with the open event. Any ideas on how I can get Excel not to crash and the AddIn function to be recognized upon starting the macro with the open workbook event? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA AddIn reference in Excel X for Mac
I can't reproduce that in either XLv.X or XL2004. What ATP function are
you using? Also, it might help if you posted your Workbook_Open code. In article , "Lori" wrote: I have installed the Analysis Toolpak and Analysis Toolpak - VBA on my Power PC G4 using Excel X for Mac. I have included one of the addin functions in a macro that starts upon opening of the workbook. Before I put the addin in my code, I had no problems with the macro starting when the workbook was opened. Once I put that in, Excel hangs and crashes upon opening the workbook. I added AddIns("Analysis Toolpak - VBA").Installed = True to the open event, but the workbook still crashed. Either way, Excel isn't recognizing the AddIn properly until I close the macro and restart it. It seems to work ok if I don't start the macro with the open event. Any ideas on how I can get Excel not to crash and the AddIn function to be recognized upon starting the macro with the open workbook event? Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA AddIn reference in Excel X for Mac
I was able to find the answer at
http://support.microsoft.com/kb/312833/EN-US/ Apparently it's a problem with Excel X for Mac. "JE McGimpsey" wrote: I can't reproduce that in either XLv.X or XL2004. What ATP function are you using? Also, it might help if you posted your Workbook_Open code. In article , "Lori" wrote: I have installed the Analysis Toolpak and Analysis Toolpak - VBA on my Power PC G4 using Excel X for Mac. I have included one of the addin functions in a macro that starts upon opening of the workbook. Before I put the addin in my code, I had no problems with the macro starting when the workbook was opened. Once I put that in, Excel hangs and crashes upon opening the workbook. I added AddIns("Analysis Toolpak - VBA").Installed = True to the open event, but the workbook still crashed. Either way, Excel isn't recognizing the AddIn properly until I close the macro and restart it. It seems to work ok if I don't start the macro with the open event. Any ideas on how I can get Excel not to crash and the AddIn function to be recognized upon starting the macro with the open workbook event? Thanks! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA AddIn reference in Excel X for Mac
In article ,
"Lori" wrote: I was able to find the answer at http://support.microsoft.com/kb/312833/EN-US/ Apparently it's a problem with Excel X for Mac. Ah, I'd forgotten that... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word with embedded Excel object which has reference to addin | Excel Discussion (Misc queries) | |||
Addin reference | Excel Programming | |||
Reference to sheet name in addIn | Excel Programming | |||
Addin / Library Reference question | Excel Programming | |||
Remove Excel AddIn from AddIn List !! Help | Excel Programming |