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?