Queener Posted February 14, 2014 Share Posted February 14, 2014 I just notice today that I run into an error when openning the xls file. What happen is when I download the Log.xls from my cooperate site, sometimes it comes as Log_414654.xls. Most of the time it comes in as Log.xls. Would like to know how I would code it so it open any file located in Downloads folder that contain Log and the extension as xls? I would assuming, I would need to throw in a wildcard... here's my previous code: Global $loc = @UserProfileDir & "\Downloads" $sFilePath = $loc & "\ESDLog.xls"; $oExcel = _ExcelBookOpen($sFilePath) ; 1= Visable 0 = Not Visable The reason I use both loc and sFilePath is because I plan to use $loc as the directory for downloads. I might need that directory for later openning other items. Msgbox(0, "Hate", "Just hate it when I post a question and find my own answer after a couple tries. But if I don't post the question, I can't seem to resolve it at all.") Link to comment Share on other sites More sharing options...
Moderators JLogan3o13 Posted February 14, 2014 Moderators Share Posted February 14, 2014 Is there only one file in that directory, or multiple xls files? "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...
water Posted February 14, 2014 Share Posted February 14, 2014 Would like to know how I would code it so it open any file located in Downloads folder that contain Log and the extension as xls? Have a look at function _FileListToArrayRec to retrieve a list of files. 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...
Queener Posted February 14, 2014 Author Share Posted February 14, 2014 Using ; A sorted list of all but the .exe files in the \AutoIt3 folder $aArray = _FileListToArrayRec(@UserProfileDir & "\Downloads\", "*.xls", 1, 0, 1) ConsoleWrite("Error: " & @error & " - " & " Extended: " & @extended & @CRLF) _ArrayDisplay($aArray, "Non .XLS files") It returns Row|Col 0 [1]|ESDLogCAC5TYG9.xls Msgbox(0, "Hate", "Just hate it when I post a question and find my own answer after a couple tries. But if I don't post the question, I can't seem to resolve it at all.") Link to comment Share on other sites More sharing options...
somdcomputerguy Posted February 14, 2014 Share Posted February 14, 2014 You could try $sFilePath = $loc & "Log_*.xls", but that would probably only work for you if there is only file, and the naming convention is the same as in your post, not in your code example. - Bruce /*somdcomputerguy */ If you change the way you look at things, the things you look at change. Link to comment Share on other sites More sharing options...
Solution water Posted February 14, 2014 Solution Share Posted February 14, 2014 (edited) #include <Array.au3> #include <MsgBoxConstants.au3> #include <Excel.au3> Global $aArray = _FileListToArrayRec(@UserProfileDir & "\Downloads\", "*.xls", 1, 0, 1) If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Error", "_FileListToArrayRec returned Error: " & @error & " - " & " Extended: " & @extended) _ArrayDisplay($aArray, "Non .XLS files") Global $loc = @UserProfileDir & "\Downloads" $sFilePath = $loc & "\" & $aArray[1] $oExcel = _ExcelBookOpen($sFilePath) Edited February 14, 2014 by water 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...
Queener Posted February 14, 2014 Author Share Posted February 14, 2014 works great. Thanks Water. Msgbox(0, "Hate", "Just hate it when I post a question and find my own answer after a couple tries. But if I don't post the question, I can't seem to resolve it at all.") Link to comment Share on other sites More sharing options...
water Posted February 14, 2014 Share Posted February 14, 2014 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