J
Johnnyboy5
I have several documents on a Pen Drive which have macros in them in
which there are some links for other file locations on the same Pen
Drive - mainly an Excel mail merge file.
e.g.
ActiveDocument.MailMerge.MainDocumentType = wdFormLetters
ActiveDocument.MailMerge.OpenDataSource Name:= _
"I:\0.1 Care planning templates\0.1 care planning raw
data.xls", _
ConfirmConversions:=False, ReadOnly:=False,
LinkToSource:=True, _
This example above shows that the file location is "I" however if I
work on another laptop or in work etc and plug in the pen drive - it
can be read as another drive like "F" or "G" and therefore the macro
fails to run.
Is there a way to make all computers recognise the pen drive as a fix
drive letter say "Z" or something like that.
The laptops could have XP or Vista or even Windows 7
Regards
Johnnyboy
which there are some links for other file locations on the same Pen
Drive - mainly an Excel mail merge file.
e.g.
ActiveDocument.MailMerge.MainDocumentType = wdFormLetters
ActiveDocument.MailMerge.OpenDataSource Name:= _
"I:\0.1 Care planning templates\0.1 care planning raw
data.xls", _
ConfirmConversions:=False, ReadOnly:=False,
LinkToSource:=True, _
This example above shows that the file location is "I" however if I
work on another laptop or in work etc and plug in the pen drive - it
can be read as another drive like "F" or "G" and therefore the macro
fails to run.
Is there a way to make all computers recognise the pen drive as a fix
drive letter say "Z" or something like that.
The laptops could have XP or Vista or even Windows 7
Regards
Johnnyboy