Consulting

Results 1 to 2 of 2

Thread: Syntax for opening file on server...

  1. #1

    Syntax for opening file on server...

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

  2. #2

    Update

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •