Copy sheet to new instance of excel

[Dumb Blond]

I have a program that exports data to excel but doesn't load an excel add-in that i need. So, i need to open a new instance of excel which loads the add-in fine, and copy the sheet over to the new instance.

I have scoured the message boards for a solution and found ideas, but can't seem to get anything to work for me. Any help would be greatly appreciated.

 

[Jaafar Tribak]

Sub RemoteLoadAddin()
    Dim xlApp As Excel.Application
   [B] Const ADDIN_PATH_NAME As String = "C:\Program Files (x86)\Microsoft Office\Office14\XLSTART\[B]il[/B]x.xla"[/B]
    
    Set xlApp = GetObject("c:\mypath\book1.xlsm").Application
    xlApp.Workbooks.Open ADDIN_PATH_NAME
End Sub

or just load the addin manually

 

[Dumb Blond]

Hi, the below does not work, but there doesn't appear to be any syntax errors either. If I double click on this file in the xlstart folder it adds the load in. How do I launch the add in this way?

Sub RemoteLoadAddin()
Dim xlApp As Excel.Application
Const ADDIN_PATH_NAME As String = "C:\Program Files (x86)\Microsoft Office\Office14\XLSTART\ilx.xll"

Set xlApp = GetObject("\\WPCONBKLONDON01\Home\M\MURRAN3\Documents\Croesus Template.xlsm").Application
xlApp.Workbooks.Open ADDIN_PATH_NAME
End Sub

 

[Andrew Poulsom]

You said originally that it was an xla. Does this work for you?

xlApp.RegisterXLL ADDIN_PATH_NAME

 

[Dumb Blond]

That seemed to work but I would like to stay with the current worksheet. Can I eliminate the this line or change the file name to current or something?

Set xlApp = GetObject("\\WPCONBKLONDON01\Home\M\MURRAN3\Documents\Croesus Template.xlsm").Application



Sub RemoteLoadAddin()
Dim xlApp As Excel.Application
Const ADDIN_PATH_NAME As String = "C:\Program Files (x86)\Microsoft Office\Office14\XLSTART\ilx.xll"
Set xlApp = GetObject("\\WPCONBKLONDON01\Home\M\MURRAN3\Documents\Croesus Template.xlsm").Application
xlApp.RegisterXLL ADDIN_PATH_NAME
End Sub

 

[Dumb Blond]

I think I understand that the file name in Set xlApp = GetObject("\\WPCONBKLONDON01\Home\M\MURRAN3\Documents\Croesus Template.xlsm").Application
is somewhat irrelevant, so i just created a BlankXLL.xlsx file to use in place of it. Appears to be working. This has eliminated the need to open a new instance of excel as well and will speed everything up.

 

[Dumb Blond]

I think I figured our what the second file in the XLStart folders does. It opens a tab on the menu bar that has a drop down and other information associated with it. If I wanted to open both files, do I use the same method?


The files are: ilx.xla and ilx.xll (both located in the XLStart Folder)

 

[Andrew Poulsom]

This may help you:

Loading Excel Add-Ins at Runtime - Accelerating Things - Site Home - MSDN Blogs