Hi all,
I'm hoping this is a nice and simple question; I have the below statement in my MS word Macro which has pulled data from MS Excel and then automatically saves it to a designated directory. Part of the VBA is shown below.
ChangeFileOpenDirectory "Q:\03. BTF Lab\LR Reports"
The problem, if you choose to accept, is for different people the Q: drive may be X: e.t.c. How do I enter it so that it doesn't have to specify Q: drive without remapping their drives?
The word file is opened is in the following path:
Q:\03. BTF Lab\Lab jobs request and monitor\Master LAB small job old data
And I want to change this to:
ChangeFileOpenDirectory "Q:\03. BTF Lab\LR Reports"
Any suggestions?
Thanks
I'm hoping this is a nice and simple question; I have the below statement in my MS word Macro which has pulled data from MS Excel and then automatically saves it to a designated directory. Part of the VBA is shown below.
ChangeFileOpenDirectory "Q:\03. BTF Lab\LR Reports"
The problem, if you choose to accept, is for different people the Q: drive may be X: e.t.c. How do I enter it so that it doesn't have to specify Q: drive without remapping their drives?
The word file is opened is in the following path:
Q:\03. BTF Lab\Lab jobs request and monitor\Master LAB small job old data
And I want to change this to:
ChangeFileOpenDirectory "Q:\03. BTF Lab\LR Reports"
Any suggestions?
Thanks
