Excel 2010 Vba Runtime Error 429
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Sat, 15 Oct 2016 08:51:59 GMT by s_ac15 (squid/3.5.20)
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site
Excel Vba 429 Activex
About Us Learn more about Stack Overflow the company Business Learn more vba activex component can't create object 429 about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss excel vba runtime error 1004 Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Run-time error '429': https://answers.microsoft.com/en-us/windows/forum/windows_xp-windows_programs/runtime-error-429-activex-component-cant-create/481475c9-4ed6-4211-be6b-2431b962b257?page=2 ActiveX component can't create object VBA up vote 4 down vote favorite I am trying to save Word docs using Excel VBA, but I get the error "ActiveX component can't create object." When I debug, the error comes from the line: Set wrdApps = CreateObject("Word.Application"). It was working fine, but then it just started giving me this error. Does anyone know how to fix this? http://stackoverflow.com/questions/17327327/run-time-error-429-activex-component-cant-create-object-vba Thanks for the help! Sub saveDoc() Dim i As Integer For i = 1 To 2661: Dim fname As String Dim fpath As String With Application .DisplayAlerts = False .ScreenUpdating = False .EnableEvents = False End With fname = ThisWorkbook.Worksheets(3).Range("H" & i).Value fpath = ThisWorkbook.Worksheets(3).Range("G" & i).Value Dim wrdApps As Object Dim wrdDoc As Object Set wrdApps = CreateObject("Word.Application") 'the next line copies the active document- the ActiveDocument.FullName ' is important otherwise it will just create a blank document wrdApps.documents.Add wrdDoc.FullName Set wrdDoc = wrdApps.documents.Open(ThisWorkbook.Worksheets(3).Range("f" & i).Value) ' do not need the Activate, it will be Activate wrdApps.Visible = False ' the next line saves the copy to your location and name wrdDoc.SaveAs "I:\Yun\RTEMP DOC & PDF\" & fname 'next line closes the copy leaving you with the original document wrdDoc.Close On Error GoTo NextSheet: NextSheet: Resume NextSheet2 NextSheet2: Next i With Application .DisplayAlerts = True .ScreenUpdating = True .EnableEvents = True End With End Sub object excel-vba activex share|improve this question edited Jun 26 '13 at 18:19 chuff 4,6551921 asked Jun 26 '13 at 18:03 user2525309 21112 This post on OzGrid may help. Only difference I saw from wh
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and http://stackoverflow.com/questions/4213496/how-do-i-resolve-run-time-error-429-activex-component-cant-create-object policies of this site About Us Learn more about Stack Overflow the http://www.runtimeerrorsfix.com/how-to-fix-runtime-error-429.html company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only runtime error takes a minute: Sign up How do I resolve “Run-time error '429': ActiveX component can't create object”? up vote 9 down vote favorite 1 My company has a VB6 application using Crystal Reports 7 which a client has asked to be installed on Windows 7 32 bit. It is currently installed on Windows XP 32bit SP2 machines at the client. Connection activex component can't to the DB is done via ODBC to SQL Server 2000 instance on another server. On Windows 7, the installation works fine, however when you try to open the application, the error is given. I have looked at the following: Registering all the dll's and ocx files using regsvr32. Some will not register as they either are registered already or the following message is given "Make sure that "[name].dll" is valid DLL or OCX file and then try again." I read this forum thread regarding this: http://social.msdn.microsoft.com/forums/en-US/vblanguage/thread/0653f685-4526-45d9-89f3-8c479a6b4c62 Monitored the opening of the application using a ProcessMonitor application to try and spot if there is a missing dll or ocx file - this does not seem to be the case. Reviewed the application according to this list and nothing seems to be against these guidelines I've noticed two items in the knowledge base that relate to this http://support.microsoft.com/kb/281848 - the comdlg32.ocx bundled with the application is version 6.0.81.69 and the one in the system32 folder on the dev machine (WinXP 32 bit) is 6.1.97.82. However if this was the issue
is Runtime Error 429? Runtime error 429 typically arrives with the message “Object creation failed” or a similarly worded message such as “ActiveX component can’t create object.” Most commonly, this error occurs because the program that the user is trying to access has been corrupted. Since the program cannot complete its action and create the requested object, runtime error 429 is generated. In particular, this error often occurs when activating Microsoft Visual Basic in connection with the Microsoft Office application. The user attempts to use the automated feature by accessing the CreateObject function or the new operator in Microsoft Visual Basic feature. How to Fix Runtime Error 429: Troubleshooting and Checking Automation Server If the application set up or configuration is at fault, you can easily check this by looking to see that the application has been installed on the operating system that you are using as well as checking to see that you can run the application manually. If the application does not run using the following directions, then it will not work when you are trying to use the automation feature either. Navigate to Start. Select Run. Type the name of the application that you are checking. Select ok. How to Fix Runtime Error 429: Re-register the Application Navigate to Start. Select Run. Type the path for the server adding /regserver at the end into the empty box that appears. For example, if you are trying to access Excel, you might type “C:\Program Files\Microsoft Office\Office\Excel.exe/regserver.” Select ok. How to Fix Runtime Error 429: Run a Registry Cleaner Download a registry cleaner. Install the registry cleaner. Run the registry cleaner to fix broken or missing files. How to Fix Runtime Error 429: Verify the Registry Entries Incorrect registry errors will also generate runtime error 429, therefore, you need to use the following set of directions to check