How do I add another drive to search for when loading the workbooks
listed below.

Problem is when I use these files on my pen drive at home / work and
other PCs the pen might be recognised as a different drive letter on
each one.

I only need it look in say "f" and "g" and that will do the job.

Many thanks

John


EXAMPLE

Workbooks.Open ("f:\Direct Payments DOT\1 payments cheryl.xls")
Workbooks.Open ("f:\Direct Payments DOT\1 payments Sandra.xls") '
Change as required
Workbooks.Open ("f:\Direct Payments DOT\1 payments Liv.xls")
Workbooks.Open ("f:\Direct Payments DOT\1 payments Sally.xls")
Workbooks.Open ("f:\Direct Payments DOT\0.5 yearly payment
planner.xls")