ALIB Excel Ad In

[Vaskosky]

HI
I am trying to create a macro in Excel to pul an EXCEL ALIB file "xlswaps.xla" to the Add-Ins. I have tryed usig the below code but it isn't working?
Sheets("setup").Select
Range("C1").Select
ActiveCell.FormulaR1C1 =OBJECT_LOAD(""http:C:\ct2\alib\18.0.0.0//)"
Range("C2").Select
ActiveSheet.Calculate


Call ImportData_4("Import_Table")
Sheets("xlswaps.xla").Select
ActiveSheet.Calculate
ActiveWorkbook.Save
End Sub

 

[RoryA]

I don't follow your code at all. What is OBJECT_LOAD? It looks as though you are attempting to embed an add-in workbook in another workbook, but I can't imagine why.

 

[Vaskosky]

Hi Rory,
Corect I need to embed the Alib Add In to another workbook in order to run a report. At the moment I am draging the ALIB folder located in ( C:\ct2\alib\18.0.0.0) to the Add-Ins on the top of the ribon in Excel. I need to create a macro to pul the file automatically.
Thank you

 

[RoryA]

Embedding an add-in is not the same as installing it - it won't make the code available to the workbook. Why do you want to embed it?

 

[Vaskosky]

Embedding an add-in is not the same as installing it - it won't make the code available to the workbook. Why do you want to embed it?

Hi I need the ALIB function to add to excel to run some data. Currently I need to drag and drop the ALIB file to excel addIns I like to set up macro to automate the process