water Posted October 10, 2013 Share Posted October 10, 2013 As AutoIt does nothing to the xlsx file I'm sure this can only be an Excel bug. Can you try on another machine in your company? Maybe reinstalling Excel could solve the problem? 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...
Imbuter2000 Posted October 10, 2013 Author Share Posted October 10, 2013 The problem is triggered only when I open the file from AutoIT. If I open it manually it's not triggered. Therefore the problem could still be anywhere in chain AutoIT - COM - Excel... In my company it happened on 3 PCs out of 4 where I tried. On the 4rd PC it happened one time in the past, not now in these tests. Link to comment Share on other sites More sharing options...
Imbuter2000 Posted October 10, 2013 Author Share Posted October 10, 2013 other info: the use of XLS format instead than XLSX avoids the problem Link to comment Share on other sites More sharing options...
water Posted October 10, 2013 Share Posted October 10, 2013 If you could open the xlsx file by COM using Visual Basic and the error persists then I dare to say it is a MS bug. 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...
Imbuter2000 Posted October 10, 2013 Author Share Posted October 10, 2013 Good idea water. I tried again: VBA (executed inside Excel): Sub test() Workbooks.Open Filename:="c:tempbug-free original copy.xlsx" End Sub AutoIT: $oE = ObjCreate("Excel.Application") $oE.Visible = 1 $oE.WorkBooks.Open("c:tempbug-free original copy.xlsx") VBA doesn't cause the problem. AutoIT causes the problem Link to comment Share on other sites More sharing options...
water Posted October 10, 2013 Share Posted October 10, 2013 Looks like it is time to open a ticket in the BugTracker. 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...
lorenkinzel Posted October 16, 2013 Share Posted October 16, 2013 Despite trying a plethora of different methods, I still can not duplicate your problem / error on excel 07 or 2010. Did make note, though; with normally opening linked workbooks a message appears asking if I want to update links. If I open linked workbook with _ExcelBookOpen it simply updates without asking. This can change or remove named ranges or filters. Not a duplication of error though. Studying Excel.au3 provides no clues (to me) to this behaviour. Not done yet. Too many unanswered questions. Link to comment Share on other sites More sharing options...
Imbuter2000 Posted October 16, 2013 Author Share Posted October 16, 2013 It happened on a clean new file too, without any links for sure... I actually "solved" using XLS instead than XLSX. Link to comment Share on other sites More sharing options...
water Posted October 16, 2013 Share Posted October 16, 2013 Often a fresh install of Office solves such strange "problems" 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...
Imbuter2000 Posted October 17, 2013 Author Share Posted October 17, 2013 Often a fresh install of Office solves such strange "problems" The strange thing is that it also happens on 3 PC out of 4 tried in my bank office (where I don't have admin rights and license for reinstalling Office)... I don't know... may be "Italian" is the only difference between my PCs and yours... Link to comment Share on other sites More sharing options...
water Posted October 17, 2013 Share Posted October 17, 2013 I have no more ideas :-( Best would be to open a Ticket on the AutoIt BugTracker. 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...
lorenkinzel Posted October 17, 2013 Share Posted October 17, 2013 I switched my computer to Italian & found no difference. Link to comment Share on other sites More sharing options...
Imbuter2000 Posted October 19, 2013 Author Share Posted October 19, 2013 I switched my computer to Italian & found no difference. Can you define "my computer"? Windows? Office? Link to comment Share on other sites More sharing options...
lorenkinzel Posted October 20, 2013 Share Posted October 20, 2013 excel options>language settings & Windows >regional & language settings So- both. It seemed (things are not always as they seem) to be the last variable I had not tried. My inability to duplicate the problem does not mean it does not occur. I am unable to duplitate this problem. Perhaps a more qualified person can. Link to comment Share on other sites More sharing options...
Imbuter2000 Posted October 27, 2013 Author Share Posted October 27, 2013 excel options>language settings & Windows >regional & language settings So- both. It seemed (things are not always as they seem) to be the last variable I had not tried. My inability to duplicate the problem does not mean it does not occur. I am unable to duplitate this problem. Perhaps a more qualified person can. What language is your Windows OS? English? Mine is Italian... and this could be the difference... Regional & language settings don't change the OS language... Link to comment Share on other sites More sharing options...
lorenkinzel Posted October 28, 2013 Share Posted October 28, 2013 My OS is english Though I am quite adventurous; OS language is one last variable that I am unwilling to deal with. No $ for the install disc, otherwise I'd give it a go......... Sorry to bail on you, but I'm bailing on you. 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