View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
sherban via OfficeKB.com sherban via OfficeKB.com is offline
external usenet poster
 
Posts: 2
Default Start Excel file on remote server

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

[quoted text clipped - 12 lines]
the opens the file I need?
Thank you.


After you create Excel.Application on a remote computer, you should be able
to open an exsisting workbook using Workbooks.Open

Set xlApp = CreateObject("Excel.Application", "MyServer")
Set objWorkbook = xlApp.Workbooks.Open ...

Depending on what you need to do, you may have problems trying to make Excel
visible:

http://msdn2.microsoft.com/en-us/library/aa262700.aspx

Thank you. I'll give it a try.

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