open word from server

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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

sirron said:
I want to open a word file from my server. But I dont ant to use this
Click to expand...
path "z:\test.doc" is there a way that I can
use the path name example (csalpha\IT\test.doc) instead of
Click to expand...
z:\test.doc. The reason for this is because other users will be looking at
this and they might be mapped differently.
 
Did this not work for you

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

-Brad Vontur
 
Back
Top