ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   XL remoting issue... (https://www.excelbanter.com/excel-programming/311339-xl-remoting-issue.html)

Alex T

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


All times are GMT +1. The time now is 12:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com