rapt3r Posted June 19, 2017 Share Posted June 19, 2017 Hi everyone, i got a script, where i open up excel attachments in outlook and copy them out with rangecopypaste into another excel file. Now, when i got alot of outlook mails and attachments after some time of perfect processing i got this error everytime: "C:\Program Files (x86)\AutoIt3\Include\Excel.au3" (227) : ==> Variable must be of type "Object".: $oExcel.Windows($oWorkbook.Name).Visible = $bVisible $oExcel.Windows($oWorkbook.Name)^ ERROR This error happens only, when i got a big amount of emails and attachments. If i run my script with "less" mails and attachments, everything works fine. This error code doesnt seem to a problem within my script, because the "excel.au3" causes it. Has someone an idea what i could do? thanks alot Link to comment Share on other sites More sharing options...
water Posted June 19, 2017 Share Posted June 19, 2017 Please download fixes for this Excel functions: My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
rapt3r Posted June 19, 2017 Author Share Posted June 19, 2017 Hi Water, you are fast as always. Unfortunately im running Version 3.3.14.2, so there is nothing to update? Link to comment Share on other sites More sharing options...
anthonyjr2 Posted June 19, 2017 Share Posted June 19, 2017 The UDFs in the latest version of AutoIt have a couple of small bugs in them. You have to open the UDFs in your include file and replace the functions with the fixed ones that water stated in that thread. UHJvZmVzc2lvbmFsIENvbXB1dGVyZXI= Link to comment Share on other sites More sharing options...
water Posted June 19, 2017 Share Posted June 19, 2017 Post #3 in the thread I mentioned above is misleading You need to update the UDFs when you run AutoIt > 3.3.12.0 My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Juvigy Posted June 19, 2017 Share Posted June 19, 2017 Have you tried putting a small sleep between the passes in your loop? I think excel just hangs a bit when working with a lot of mails and files. Link to comment Share on other sites More sharing options...
water Posted June 19, 2017 Share Posted June 19, 2017 Never seen the need to insert Sleep statements when working with the Excel UDF. It uses COM so the script execution only continues when the previous command has finished processing. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
rapt3r Posted June 19, 2017 Author Share Posted June 19, 2017 (edited) Ok, ive updated as mentioned and the script runs better i think. But now i have a new Problem. Around 3:40 MIN autoit crashes... Getting the error "autoit3.exe has stopped working" and there is this message when debugging: An unhandled win32 exception occured in autoit3.exe [8952] Tried it two times and it crashes at the same spot. Is there any crashlog, when the programm crashes? Edited June 19, 2017 by rapt3r Link to comment Share on other sites More sharing options...
water Posted June 19, 2017 Share Posted June 19, 2017 If you search the forum (or the web) you will find some threads on this issue. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
rapt3r Posted June 19, 2017 Author Share Posted June 19, 2017 39 minutes ago, water said: If you search the forum (or the web) you will find some threads on this issue. Have tried to find something, but it seems i cant find something useful. I manage to process around 30-40 attachments and then autoit crashes everytime. Im getting this exit code: 3221225477. Is there any hope? Link to comment Share on other sites More sharing options...
rapt3r Posted June 19, 2017 Author Share Posted June 19, 2017 Ok. Got a new finding. When im running my Script with the x64 bit version of autoit. Then it works... Tomorrow i will test it with more data. Link to comment Share on other sites More sharing options...
water Posted June 19, 2017 Share Posted June 19, 2017 So the questions is: Which version of Excel do you run? 32 or 64 bit? My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
rapt3r Posted June 20, 2017 Author Share Posted June 20, 2017 15 hours ago, water said: So the questions is: Which version of Excel do you run? 32 or 64 bit? ok, did a few testings and found out, that my script works perfectly when running my script with x64. So problem fixed. checked the excel version and im running 2013 with 32bit. Unfortunately i cant upgrade to x64 excel here. Link to comment Share on other sites More sharing options...
water Posted June 20, 2017 Share Posted June 20, 2017 Usually you need to run AutoIt as 64bit when Office is 64bit. But it seems something else in your script needs 64bit. Without having seen your code this is where the story ends My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
rapt3r Posted June 20, 2017 Author Share Posted June 20, 2017 (edited) 8 minutes ago, water said: Usually you need to run AutoIt as 64bit when Office is 64bit. But it seems something else in your script needs 64bit. Without having seen your code this is where the story ends Ah you mean, that autoit would run automatically in x64, when excel would be in x64 also? Then you got a typo in your text;) Thanks alot for your fast help! btw. is there a statement which can be build in, to force autoit to run in x64? Edited June 20, 2017 by rapt3r Link to comment Share on other sites More sharing options...
water Posted June 20, 2017 Share Posted June 20, 2017 No, Autoit does not run automatically in x64. You need to compile for x64 when you use the 64bit version of Office and any of the Office UDFs. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
rapt3r Posted June 20, 2017 Author Share Posted June 20, 2017 1 minute ago, water said: No, Autoit does not run automatically in x64. You need to compile for x64 when you use the 64bit version of Office and any of the Office UDFs. hmm. but my office runs in 32bit and when im compiling in x64, everything works perfectly. so i dont necessarly have to use office 64bit? Link to comment Share on other sites More sharing options...
water Posted June 20, 2017 Share Posted June 20, 2017 Correct. rapt3r 1 My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
anthonyjr2 Posted June 20, 2017 Share Posted June 20, 2017 5 hours ago, rapt3r said: is there a statement which can be build in, to force autoit to run in x64? Put this at the top of your code: #AutoIt3Wrapper_UseX64=Y rapt3r 1 UHJvZmVzc2lvbmFsIENvbXB1dGVyZXI= 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