Hi,
I've written a script on a workbook that runs on startup, imports a bunch of .bas and .frm files into the personal.xls, and then closes. The point of this is to update, over a WAN, 500+ employees Excel to contain macros and menus for the macros
It works great EXCEPT for one .frm file which contains a common dialog control. Can anyone tell me if this is a specific issue with the CommonDialog - and maybe this is why I should drop it in a COM, or better yet if you know of a fix for this?
The error Message is:
Run-time error '60061':
Errors during load. Refer to *points to import file*
When I hit debug, it comes in on the line that imports the .frm file.
Thanks!
Crabback
I've written a script on a workbook that runs on startup, imports a bunch of .bas and .frm files into the personal.xls, and then closes. The point of this is to update, over a WAN, 500+ employees Excel to contain macros and menus for the macros
It works great EXCEPT for one .frm file which contains a common dialog control. Can anyone tell me if this is a specific issue with the CommonDialog - and maybe this is why I should drop it in a COM, or better yet if you know of a fix for this?
The error Message is:
Run-time error '60061':
Errors during load. Refer to *points to import file*
When I hit debug, it comes in on the line that imports the .frm file.
Thanks!
Crabback
