View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alex T Alex T is offline
external usenet poster
 
Posts: 24
Default XL remoting issue...

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