-
Active X component cant create object
Hello all,
I have a problem. I would like to open userform after opening one workbook. (With workbook_open action and with userform.show) It works great but only when, there is no other workbook opened on my computer. Since excel is already running, by using different workbook. I always gets this error message Active X component cant create object and I am not able to solve this fail. Any help would be welcome.
-
somewhere there is some VBA code with 'createobject' or 'getobject'.
-
Actually, I am using createobject for creating new excel workbook, pdf file and outlook, but this is located in modul. These moduls are loceted in different userform then I want to call with workbook open action. I would expect, that it shouldnt have any impact on my project Do you have any suggestion, how should I replace createobject, or any other idea?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules