johndoe123 Posted May 14, 2013 Share Posted May 14, 2013 Hi Everyone I am new to AutoIt and would like to write a script to open an Excel file, do a bunch of operations on a specific worksheet within it, and then save it. The password protected spreadsheet that I am opening has data links to other spreadsheets and so, when opening it prompts stating that "This workbook contains links to other data sources. Do you want to update? or something similar". Here is what I have to open the file right now: Local $oExcel = _ExcelBookOpen($ScriptLocation & "" & "Some Spreadsheet.xls",True,False,"some password") Dim $title = "Microsoft Excel" Dim $text = "This workbook contains links to" WinWait($windowTitle, $windowText,0) If Not WinActive($title,$text) Then WinActivate($title,$text) WinWaitActive($title,$text,0) Send("{ENTER}") ;send an enter key to choose the default update button ;do something to the spreadsheet and save it ;end of operation The problem is that the WinWait approach does not seem to work here, and does not recognize the . What I am doing wrong? Thanks Sara Link to comment Share on other sites More sharing options...
johndoe123 Posted May 14, 2013 Author Share Posted May 14, 2013 I am using the Excel UDF to open the file by the way. Thanks Link to comment Share on other sites More sharing options...
water Posted May 15, 2013 Share Posted May 15, 2013 Please have a look at my rewrite of the Excel UDF - got download please check my signature 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...
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