Error 429 Vba
Contents |
360 games PC games runtime error '429' activex component can't create object vba Windows games Windows phone games Entertainment All Entertainment
Error 429 Activex Component Can't Create Object Excel
Movies & TV Music Business & Education Business Students & educators runtime error 429 activex component can't create object excel Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet activex component can't create object excel vba Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All
Excel Vba Activex Component Can't Create Object 429
Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
here for a quick overview of the site Help Center Detailed answers to any questions you might error 429 activex windows 7 have Meta Discuss the workings and policies of this site About runtime error 429 activex component can't create object windows xp Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads
Runtime Error 429 Activex Component Can't Create Object Windows 8
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 https://support.microsoft.com/en-us/kb/828550 programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Run-time error '429': 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 http://stackoverflow.com/questions/17327327/run-time-error-429-activex-component-cant-create-object-vba 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? 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: N
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings http://stackoverflow.com/questions/4213496/how-do-i-resolve-run-time-error-429-activex-component-cant-create-object and policies of this site About Us Learn more about Stack Overflow the 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 activex component 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. activex component can't Connection 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 i