Excel 2010 Vba Error 429
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 13 Oct 2016 20:50:53 GMT by s_ac4 (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 About Us Learn more about Stack Overflow the company Business Learn more runtime error 429 activex component can't create object windows 10 about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges
Runtime Error 429 Activex Component Can't Create Object Windows 8
Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each
Activex Component Can't Create Object Excel 2013
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 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 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? 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 http://stackoverflow.com/questions/17327327/run-time-error-429-activex-component-cant-create-object-vba = 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 what you have is that wrd.Apps would be set as Word.Application and wrd.Doc would be set as Word.Document. –chuff Jun 26 '13 at 18:26 try running a repair on Office, and restart your pc ... the code you have CreateObject("Word.Application") should work fine –Our Man In Bananas Jun 27 '13 at 11:42 add a comment| 2 Answers 2 active oldest votes up vote 0 down vote Is wrdDoc initialised? Are you trying to use wrdDo
here for a quick overview of the site Help Center Detailed answers to any http://stackoverflow.com/questions/17557604/run-time-error-429-activex-component-cant-create-object-automate-ms-word-appl questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more http://www.ibm.com/support/docview.wss?uid=swg21661396 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 error 429 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, ActiveX component can't create object, automate MS Word application, CreateObject(“Word.Application”) up vote 7 down vote favorite 2 I'm running into the following error when executing the activex component can't following line from VBA (Access): Set wd = CreateObject("Word.Application") I found the following link, but did not find it useful: http://support.microsoft.com/kb/828550 Things I've Tried Repair installation of Office from Control Panel > Programs and Features Uninstall MS Word, re-install Tried Dim wd As Object instead of Dim wd as Word.Application Manually run Word. Run winword.exe /RegServer in Administrator command prompt. Did not run silently, merely opened Word. Examine the LocalServer32 key under the CLSID {000209FF-0000-0000-C000-000000000046}. Initially was missing. After re-install Word, the CLDID was there but LocalServer32 key is missing. Run winword.exe /automation. Merely starts Word. Run winword.exe as Administrator. Run access.exe as Administrator. Relevant (maybe) Windows 8 x64 Office 2007 C:\Program Files (x86)\Microsoft Office\Office12 A preview version of Office 2010 was pre-installed. Launching Excel works with automation and VBA. asycfilt.dll file version: 6.2.9200.16384, date: 7/25/2012 11:05pm oleaut32.dll file version: 6.2.9200.16384, date: 7/25/2012 11:06pm olepro32.dll missing stdole2.tlb no file version, date: 7/25/2012 1
Component Can't Create Object Technote (troubleshooting) Problem(Abstract) Unable to use the Analyst Excel Add-in following new installation of Planning 10.1.1 The following error occurs immediately when Excel is opened with the Analyst Add-in enabled. With the Analyst Add-in disabled error does not occur If one clicks End to the error message, Excel opens fine but one cannot utilize the Analyst Add-in. Symptom Error: Microsoft Visual Basic Run-time error '429': ActiveX component can't create object End Cause The Analyst Excel Add-in is pointing to an older version of the Analyst.xla file. Environment Planning 10.1.1 FP2 Office 2010 32 bit Resolving the problem STEPS: 1. Open Excel and confirm location of the Analyst.xla file being used. For Office 2010: In Excel>select File menu>Click Options>Click Add-Ins Locate Analyst Add-in in the list and its location. 2. If not using the Analyst.xla file from the installation bin directory, change the location to the bin directory. Click Go (at bottom of the Add-ins screen where it specifies Manage Excel Add-ins) Select Analyst Add-in in the list and select Browse and locate Analyst.xla file in bin directory. Select OK to pop-up message that file already exists. 3. If error persists: From a working machine or from the Planning Administrator Server, copy the Analyst.xla file from bin directory. 4. Backup the existing Analyst.xla in the bin directory of the non-working machine 5. Once done, delete the file and copy the Analyst.xla file (from Step 3) into the bin directory 6. Open Excel and Log onto the Analyst Excel Addin Document information More support for: Cognos Planning Analyst ExcelAddIn Software version: 10.1.1 Operating system(s): Windows Reference #: 1661396 Modified date: 2014-01-07 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility