I have written a macro that opens a number of workbooks from a network drive
using Excel. I would like this macro to be used by a number of users. However
users have the drive name on different letters eg on my computer A:\network
drive\file.xls but on colleagues it is B:\network drive\file.xls Can I get
the macro to be dynamic and point to the drive name rather than use the
letter as it returns an error unless the drive is on the same letter name as
I have written in the macro

Regards