When open an Excel containing a add in with the Excel VBO the add in disappear, if I open the same Excel manually it contains the add in. The addin contains code to be executed later on. Any ideas how to open the file without losing the add in?
Looks like two options:
1) Start excel outside of excel vbo, then attach to that instance.
2) Google says you can load addin. Something like this in VBO: xlApplication.Workbooks.Open(xlApplication.LibraryPath & ""\MSQUERY\XLQUERY.XLAM"")
