Open .xls file

[Queener]

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.

[JLogan3o13]

Is there only one file in that directory, or multiple xls files?

[water]

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.

[Queener]

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

[somdcomputerguy]

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.

[water]

#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

[Queener]

works great. Thanks Water.

[water]