I have successfully used this code on my machine, it correctly points to the folder on drive G: as defined in the code. However, on the machine of one of my colleagues, which has also a drive G:, the dialogue points to drive H: ???!!
how to fix it?
SourceWb = Application.GetOpenFilename("Excel Files (*.xls), *.xls") 'Allows for user to select file
If SourceWb = False Then
MsgBox "You didn't select a file!"
Workbooks.Open SourceWb 'Open source workbook\