Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
personal.xlsb not loaded when excel is called by 3rd party applica
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
personal.xlsb not loaded when excel is called by 3rd party applica
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|