open word from server

[Guest]

I want to open a word file from my server. But I dont ant to use this path "z:\test.doc" is there a way that I ca
use the path name example (csalpha\IT\test.doc) instead of z:\test.doc. The reason for this is because other users will be looking at this and they might be mapped differently
thanks in advance

Dim App As Objec
Set App = CreateObject("Word.Application"
App.documents.Open "Z:\test.doc
App.Visible = True

 

[Nikos Yannacopoulos]

This is really a very good prectice, do it!
Use a UNC address instead of the mapping, which is based on the server name,
ratyer than a user-specific mapping. It would look something like
\\ServerName\FolderName1\FolderName2\...\test.doc
If you don't know the name of the server, open the Windoes Explorer and
locate the file you want by opening Network Neighbourhood, not a drive
mapping. When you get there, the full UNC path will be available for you in
the address bar to copy and paste.

HTH,
Nikos

I want to open a word file from my server. But I dont ant to use this

path "z:\test.doc" is there a way that I can

use the path name example (csalpha\IT\test.doc) instead of

z:\test.doc. The reason for this is because other users will be looking at
this and they might be mapped differently.

 

[Guest]

Did this not work for you

set doc = app.Documents.Open("\\csalpha\IT\test.doc"

-Brad Vontur