Sign in to follow this  
Followers 0
skafreak_510

Opening a worksheet

5 posts in this topic

How do I open an Excel worksheet in excel?

thanks

Share this post


Link to post
Share on other sites



How do I open an Excel worksheet in excel?

thanks

File/open B):o:graduated:

Seriously, if you look in Scripts and Scraps you will find a UDF for working with Excel.



Get Beta versions Here Get latest SciTE editor Here AutoIt 1-2-3 by Valuater - A great starting point.

Time you enjoyed wasting is not wasted time ......T.S. Elliot
Suspense is worse than disappointment................Robert Burns
God help the man who won't help himself, because no-one else will...........My Grandmother

Share this post


Link to post
Share on other sites

File/open B):o:graduated:

Seriously, if you look in Scripts and Scraps you will find a UDF for working with Excel.

Sorry, I didn't look in Scripts and Scraps. I think I found the post you were talking about it was elaborate, I might you some of that info for later.

But what I want is it to open Excel and with my Spread Sheet shown, so that I can edit it myself. The information might have been in Scripts and Scraps but I wasn't able to find it.

Should I use a run command? with a working dir? i'm not sure how to do it.

thanks,

sorry for the inconvenience.

Share this post


Link to post
Share on other sites

$full_path_to_file = "C:\Temp\New Folder\1.xls"
Run(@ComSpec & " /c " & '"' & $full_path_to_file & '"', "", @SW_HIDE)
see if that works for you...


[size="1"][font="Arial"].[u].[/u][/font][/size]

Share this post


Link to post
Share on other sites

#5 ·  Posted (edited)

Sorry, I didn't look in Scripts and Scraps. I think I found the post you were talking about it was elaborate, I might you some of that info for later.

But what I want is it to open Excel and with my Spread Sheet shown, so that I can edit it myself. The information might have been in Scripts and Scraps but I wasn't able to find it.

Should I use a run command? with a working dir? i'm not sure how to do it.

thanks,

sorry for the inconvenience.

Try

Run("excel.exe filename.xls", "Working Directory", @SW_MAXIMIZE)
Edited by BigDod


Get Beta versions Here Get latest SciTE editor Here AutoIt 1-2-3 by Valuater - A great starting point.

Time you enjoyed wasting is not wasted time ......T.S. Elliot
Suspense is worse than disappointment................Robert Burns
God help the man who won't help himself, because no-one else will...........My Grandmother

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  
Followers 0