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?

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???



Scott wrote:

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?

--

Dave Peterson