-
using sp_oamethod to add 'add-ins' in excel 2000
I'm trying to figure out the syntax of using the sp_oamethod SQL 7.0 ole extended stored procedure to execute the 'Add-Ins' in excel to add in the 'Analysis Tool Pak - VB'. I know that I can do this in an excel macro by executing:
AddIns("Analysis ToolPak - VBA".Installed = True
OR
AddIns.Add("C:Program FilesMicrosoft Office 2000officeLibraryAnalysisAnalys32.xll".Installed = True
But, I'm not sure as to how to use them from SQL 7.0. Any help on the syntax of the sp_oamethod would be helpful.
Thanks
GG
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|