urkec wrote:
I have an Excel file that I need to open remotely. The tricky part is that it
has to run on an Excel instance on that remote server. This means that
sharing the directory doeasn't work because the file will open an instance on
my computer. Also remote desktop its not OK because will open another
instance on that remote server. I would appreciate any help. Thank you.

CreateObject function has an optional parameter that lets you specify the
computer name where the object will be created. Is this not what you want?

Being just a VB novice I had to look up the CreateObject function. Indeed it
looks like this is what I need to use. However in the exemple I found on the
microsoft site they were creating a new file and writing a value in a cell.
Does the function work with just opening an exisitng file and doing nothing
with it? Or I have to create a new file like in the exemple and run a macro
the opens the file I need?
Thank you.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200803/1