VBA - Startpoint for allowing a user to pick a path

[SarahLinn]

I am currently using the code below to allow a user to select the path to save a copy on the file.

folderpath = GetFilePathandName("Please select folder for finalized workbook.", False)
If folderpath = "" Then GoTo Cancel_Routine

However I would like to set the startpoint for the user. So they can be lead in the direction I would like them to save the file. Does anyone know how to do this?

Thanks!

 

[Ralajer]

Welcome to the board Sarah Linn

You would have to change the current directory using the ChDir function.

The below code changes it just for when you need and then changes it back.

'// Get original path
preRunDir = CurDir
'// Change dir to desired path
ChDir ("C:\Start\Point")

'// CODE
folderpath = GetFilePathandName("Please select folder for finalized workbook.", False)
If folderpath = "" Then GoTo Cancel_Routine

'// Reset Dir to prechange path
ChDir (preRunDir)