Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum issue Tim Hill[_2_] Excel Worksheet Functions 1 October 14th 08 06:20 PM
issue.... pierre Excel Discussion (Misc queries) 3 May 11th 08 06:24 PM
Different day, different IF issue punter Excel Discussion (Misc queries) 6 June 20th 06 01:52 PM
Yet another issue VegasBurger Excel Worksheet Functions 5 June 14th 06 10:22 PM
Referencing .Net Remoting Services project in MS Excel Macro Shilpa Excel Discussion (Misc queries) 0 April 10th 06 11:44 AM


All times are GMT +1. The time now is 07:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"