personal.xlsb not loaded when excel is called by 3rd party applica

S

Scott

We use a 3rd party application that compiles the data for excel, and calls
the excel.exe automatically. I've put together some macro's which are saved
in my personal.xlsb.

When I open excel manually, the macro's are there (the personal.xlsb is
loaded).

However, when this application calls excel.exe and loads the data into the
worksheet, the personal.xlsb is not loaded at the same time and none of the
macros are present. I can import the .bas file which contains the macro's,
but this is kind of cumbersome to have to do this for each workbook. Does
anyone know how to overcome this dillema?
 
D

Dave Peterson

I'd use use ctrl-o (or Office button|open) to open the personal.xlsb file.

I bet there isn't much chance that the developer would change the behavior to
open your addins/files in your xlstart folder. Am I wrong???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top