Consulting

Results 1 to 3 of 3

Thread: Active X component cant create object

  1. #1

    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.

  2. #2
    Knowledge Base Approver VBAX Wizard
    Joined
    Apr 2012
    Posts
    5,645
    somewhere there is some VBA code with 'createobject' or 'getobject'.

  3. #3
    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
  •