I am not sure if below question is allowed in this forum as there is no help required for VBA program.
I am using Windows XP and Office 2007. Whenever I try to run a VBA Excel File I get a Run Time Error 429 , Active X component cant create object.
The same file works perfectly fine in another PC, I have even tried to re-install office 2007 but same problem still comes.
Re: Run Time Error 429
Start by checking all of your references in Tools>References
was the workbook created in another version of windows/office?
Re: Run Time Error 429
I am having same version of Office, but windows version is different in both PC,
The PC where I get error I have windows XP, and other PC where the file is working fine has Windows 7.
This workbook was created in windows XP, but edited and imporved VBA in Windows 7 PC.
All the references are proper.
Re: Run Time Error 429
Quote from skamat;729971
The PC where I get error I have windows XP, and other PC where the file is working fine has Windows 7.
Sounds you are referencing the object that doesn't supported by XP, such like System.Collections....
Re: Run Time Error 429
Can you post the code that isn't working, and then we can check if you are using incompatible code, as jindon has suggested - which I suspect is the case.
Re: Run Time Error 429
Sorry for late reply
After lot of search on the internet I finally got the solution which I wish to share here in case others face the same problem.
To solve th error I Reregistered the dlls
Don’t have an account yet? Register yourself now and be a part of our community!
