Jump to content
Sign in to follow this  
skafreak_510

Opening a worksheet

Recommended Posts

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.



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

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


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  

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...