This page on "Creating An XLA Add-In For Excel" indicates that the folder referenced by the Application.UserLibraryPath property is the right place to save a user-defined add-in. However, in Excel 2004 for Mac, that property doesn't seem to be defined for the Application object.
Does anyone know if there's an equivalent concept in that variant of Excel? It wouldn't necessarily have to be a property of a VBA object, but just a common place to put user-defined Add-Ins that Excel will reliably consult.
There is an Add-Ins folder (
/Applications/Microsoft Office 2004/Office/Add-Ins/), but my instinct is that that folder is for vendor-supplied add-ins, not user-defined ones.
(Or am I just being overly cautious? Should I just save my add-in to that
Add-Ins/ folder and call it good?)