Jump to content
Sign in to follow this  
Queener

Open .xls file

Recommended Posts

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.


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.")

Share this post


Link to post
Share on other sites
JLogan3o13

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


√-1 2^3 ∑ π, and it was delicious!

Share this post


Link to post
Share on other sites
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.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2018-09-01 - Version 1.3.4.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites
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

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.")

Share this post


Link to post
Share on other sites
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.


- Bruce /*somdcomputerguy */  If you change the way you look at things, the things you look at change.

Share this post


Link to post
Share on other sites
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 by water

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2018-09-01 - Version 1.3.4.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites
Queener

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.")

Share this post


Link to post
Share on other sites
water

:)


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2018-09-01 - Version 1.3.4.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×