XL remoting issue...

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Alex T (google_at_atc.ch)
Date: 09/24/04 

Date: 24 Sep 2004 07:50:22 -0700

Hello

I have some (working) code where I use Excel on a remote machine
My problem is that I can't seem to have access to network resources.
Let's assume the following code snippet

    Set xlApp = CreateObject("Excel.Application", serverName)
    xlApp.Workbooks.Open "C:\MyDIr\aFile.xls"

This works fine as long as I try to open a *local* file

However trying to access a remote file doesn't work...

    xlApp.Workbooks.Open "\\AServer\MyDIr\aFile.xls"

I guess there should be some security related restrictions but I'm not
sure which

Any idea ?

--alexT

Relevant Pages

  • Re: Running Applications from our Local Intranet page only?
    ... But if you want the user to be able to actually interact with Excel ... I'm not sure the OP wants to run Excel on the remote machine. ... on an intranet page that starts an app on the local machine; ...
    (alt.html)
  • Re: Running Applications from our Local Intranet page only?
    ... But if you want the user to be able to actually interact with Excel ... I'm not sure the OP wants to run Excel on the remote machine. ... Correct really, we dont want to interact with Excel etc, just open the page. ... Basically its because all the staff use that intranet for everything, ie its always visible, everything they are doing comes from that, so the idea is, having likes to applications makes things even easier for them. ...
    (alt.html)
  • Re: See if there are Internet-connection
    ... or open a remote file, if that works you have connection, if not than you ... don't or the remote machine is down. ... Of course the more servers you check against the more reliable you will have, of course when a servers is down or the path to them has some problem the longer it will take to run the script. ...
    (alt.php)
  • Re: See if there are Internet-connection
    ... J.O. Aho skrev: ... or open a remote file, if that works you have connection, if not than you ... don't or the remote machine is down. ...
    (alt.php)