Jump to content

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

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.

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

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
  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...