Automating Excel using UNC path.

[hjohnson]

I need to be able to be able to modify an Excel file that happend to reside only in an UNC path. When trying to save, I get a invalid path Ole error.

Is there something I am doing wrong and if so, can someone point me in the right direction.

thanks

Hj

 

[Mike Gagnon]

Can you post your code, we may be able to spot the problem. Have you put the path in quotation marks?

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[hjohnson]

I think I may have figured out part of the problem- I'm using sys(5)+sys(2003) to setup full path of the file. For some reason sys(2003) is returning an Empty string. so instead of getting "\\Documents\newfile.xls", all I am getting is "\\newfile.xls"

As soon I can solve that it looks like UNC path should work just fine.

Thanks