Opening a worksheet

[skafreak_510]

How do I open an Excel worksheet in excel?

thanks

[BigDod]

How do I open an Excel worksheet in excel?

thanks

File/open

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

[skafreak_510]

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.

[herewasplato]

$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...

[BigDod]

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 November 8, 2005 by BigDod