Hi,
I'm trying to write a macro that will open and save a file from a lan drive
that may have different drive letters depending on what each person wanted?
I've been susessful in getting a file to open with my current mapped drive
but i won't work if other people use it.

MyFile = Dir$("G:\Daily\Report *.xls*")
Do While MyFile < ""
DirectoryListArray(Counter) = MyFile
MyFile = Dir$
Counter = Counter + 1
Loop

ReDim Preserve DirectoryListArray(Counter - 1)

Thanks for any help,
Josh