skafreak_510 Posted November 8, 2005 Share Posted November 8, 2005 How do I open an Excel worksheet in excel? thanks Link to comment Share on other sites More sharing options...
BigDod Posted November 8, 2005 Share Posted November 8, 2005 How do I open an Excel worksheet in excel?thanksFile/open 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 comment Share on other sites More sharing options...
skafreak_510 Posted November 8, 2005 Author Share Posted November 8, 2005 File/open 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 comment Share on other sites More sharing options...
herewasplato Posted November 8, 2005 Share Posted November 8, 2005 $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] Link to comment Share on other sites More sharing options...
BigDod Posted November 8, 2005 Share Posted November 8, 2005 (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.TryRun("excel.exe filename.xls", "Working Directory", @SW_MAXIMIZE) Edited November 8, 2005 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 comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now