Specify a certain directory for getopenfilename

[Gingertrees]

Part of my macro prompts the user to select an Excel file to open:

Dim fn As String
    fn = Application.GetOpenFilename

The files will always be in a certain folder, arduous to get to:
\\Mainserver\Departments\dept12\TPS Reports\daily\TPS Rpt
Any way I can go directly there? Such that, when code runs, the Open window is in that folder?

 

[Andrew Poulsom]

GetOpenFileName uses the current path. So try using ChDrive and ChDir to set it.

 

[Gingertrees]

Thanks!