PDA

View Full Version : Active X component cant create object



petroj02
01-22-2017, 11:27 PM
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.

snb
01-23-2017, 01:44 AM
somewhere there is some VBA code with 'createobject' or 'getobject'.

petroj02
01-23-2017, 10:30 PM
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?