PDA

View Full Version : Syntax for opening file on server...



here4real
04-24-2012, 01:45 PM
I have many macros coded in VBA for Word on PCs... I am attempting to copy the module to Word for Mac... I can export and import the module fine... My problem is that reference for the server is obviously different...

For the PC version, I have:

Documents.Open FileName:="\\JM\USERS\USERS\SHARED\WordDrop\Administration\Hotel Rates.doc"

On the Mac, I have the Shared folder already accessed on available on the bottom... How would I have to modify this to work on the Mac???

Thanks...

here4real
04-25-2012, 12:34 PM
I figured out part of this...

I changed

Documents.Open FileName:="\\JM\USERS\USERS\SHARED\WordDrop\Administration\Hotel Rates.doc"

to

Documents.Open FileName:="\\JM:USERS:USERS:SHARED:WordDrop:Administration:Hotel Rates.doc"

The error message that it can't find the file is gone and the macro doesn't go into debug... However, it doesn't open the file either...