frigopontevedra Posted November 30, 2018 Share Posted November 30, 2018 Hi everyone, After this ; Local $oExcel = _Excel_Open() If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeWrite Example", "Error creating the Excel application object." & @CRLF & "@error = " & @error & ", @extended = " & @extended) Appears always this error: error = 1, extended = -2147221005 Please, I really interested to find the full list of @extended codes to understand the problem. Anybody knows who has the list of @extended codes? Thanks for reading me. Link to comment Share on other sites More sharing options...
frigopontevedra Posted November 30, 2018 Author Share Posted November 30, 2018 @error = 1 means: "Unable to create Outlook Object. See @extended for details (@error returned by ObjCreate)" @extended = -2147221005 (dec) = 0x800401F3 (hex) and means: "Invalid class string (Exception from HRESULT: 0x800401F3 (CO_E_CLASSSTRING))" Link to comment Share on other sites More sharing options...
water Posted November 30, 2018 Share Posted November 30, 2018 This means: Excel is not installed on the computer. My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki Link to comment Share on other sites More sharing options...
Moderators JLogan3o13 Posted November 30, 2018 Moderators Share Posted November 30, 2018 Moved to the appropriate forum. Moderation Team frigopontevedra 1 "Profanity is the last vestige of the feeble mind. For the man who cannot express himself forcibly through intellect must do so through shock and awe" - Spencer W. Kimball How to get your question answered on this forum! Link to comment Share on other sites More sharing options...
frigopontevedra Posted November 30, 2018 Author Share Posted November 30, 2018 28 minutes ago, JLogan3o13 said: Moved to the appropriate forum. Moderation Team Not only Excel is installed on this computer...in fact it is Excel 2016. Why did you move my Post? Link to comment Share on other sites More sharing options...
water Posted November 30, 2018 Share Posted November 30, 2018 Is this a full version or a trial/student version you did install? My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki Link to comment Share on other sites More sharing options...
water Posted November 30, 2018 Share Posted November 30, 2018 We once had a similar problem with Outlook as described here: My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki Link to comment Share on other sites More sharing options...
frigopontevedra Posted November 30, 2018 Author Share Posted November 30, 2018 Oh my God! Since 2013 with the same problem...and Autoit has no idea about how solve a simple missing ole object missing: Windows error 0x800401F3, -2147221005: CO_E_CLASSSTRING Spoiler ♪,,,,♪ Link to comment Share on other sites More sharing options...
frigopontevedra Posted November 30, 2018 Author Share Posted November 30, 2018 https://support.microsoft.com/en-gb/help/291392/excel-com-add-ins-and-automation-add-ins Link to comment Share on other sites More sharing options...
nobbitry Posted November 30, 2018 Share Posted November 30, 2018 33 minutes ago, frigopontevedra said: Since 2013 with the same problem...and Autoit has no idea about how solve a simple missing ole object missing: You are a jerk. Link to comment Share on other sites More sharing options...
water Posted November 30, 2018 Share Posted November 30, 2018 frigopontevedra, Please reread my posts and the thread I linked you to. It's not an AutoIt problem but a problem with your Office installation. My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki Link to comment Share on other sites More sharing options...
Moderators JLogan3o13 Posted November 30, 2018 Moderators Share Posted November 30, 2018 1 hour ago, nobbitry said: You are a jerk. This is unnecessary, and adds nothing to the thread. Correct or not, please keep your opinions to yourself. "Profanity is the last vestige of the feeble mind. For the man who cannot express himself forcibly through intellect must do so through shock and awe" - Spencer W. Kimball How to get your question answered on this forum! Link to comment Share on other sites More sharing options...
BrewManNH Posted December 1, 2018 Share Posted December 1, 2018 18 hours ago, frigopontevedra said: Why did you move my Post? He moved your post because you posted it in the wrong forum and it was moved to the proper forum. If I posted any code, assume that code was written using the latest release version unless stated otherwise. Also, if it doesn't work on XP I can't help with that because I don't have access to XP, and I'm not going to.Give a programmer the correct code and he can do his work for a day. Teach a programmer to debug and he can do his work for a lifetime - by Chirag GudeHow to ask questions the smart way! I hereby grant any person the right to use any code I post, that I am the original author of, on the autoitscript.com forums, unless I've specifically stated otherwise in the code or the thread post. If you do use my code all I ask, as a courtesy, is to make note of where you got it from. Back up and restore Windows user files _Array.au3 - Modified array functions that include support for 2D arrays. - ColorChooser - An add-on for SciTE that pops up a color dialog so you can select and paste a color code into a script. - Customizable Splashscreen GUI w/Progress Bar - Create a custom "splash screen" GUI with a progress bar and custom label. - _FileGetProperty - Retrieve the properties of a file - SciTE Toolbar - A toolbar demo for use with the SciTE editor - GUIRegisterMsg demo - Demo script to show how to use the Windows messages to interact with controls and your GUI. - Latin Square password generator Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now