J
Jim
I'm trying to write a sub that will automatically make a copy of the active
document and save it on a network drive in a folder with the author's name.
The folders already exist on the network. But I can't figure out how to
access the document's AUTHOR field.
For brevity's sake here is the crux of my problem.
DIM strNetFile
' Creates the drive/path/filename string for the saveas statement
LET strNetFile = "G:\" & ACTIVEDOCUMENT.AUTHOR & "\" & ACTIVEDOCUMENT.NAME
ACTIVEDCUMENT.SAVE ' Saves document to user's PC
FILESAVEAS .......... ' Saves copy to network
ACTIVEDOCUMENT.CLOSE ' All done
Obviously ACTIVEDOCUMENT.AUTHOR isn't working.
Any suggestions?
BTW FILECOPY was a dead end.
When I tried to FILECOPY with the document still "active", I got an error
stating I can't copy an open file .....duh... but then when I tried to
FILECOPY with the document closed, I got an error telling I had to have the
file open????
document and save it on a network drive in a folder with the author's name.
The folders already exist on the network. But I can't figure out how to
access the document's AUTHOR field.
For brevity's sake here is the crux of my problem.
DIM strNetFile
' Creates the drive/path/filename string for the saveas statement
LET strNetFile = "G:\" & ACTIVEDOCUMENT.AUTHOR & "\" & ACTIVEDOCUMENT.NAME
ACTIVEDCUMENT.SAVE ' Saves document to user's PC
FILESAVEAS .......... ' Saves copy to network
ACTIVEDOCUMENT.CLOSE ' All done
Obviously ACTIVEDOCUMENT.AUTHOR isn't working.
Any suggestions?
BTW FILECOPY was a dead end.
When I tried to FILECOPY with the document still "active", I got an error
stating I can't copy an open file .....duh... but then when I tried to
FILECOPY with the document closed, I got an error telling I had to have the
file open????