VBA Change Default File Prompt Folder

VBA Change Default File Prompt Folder

Change the default folder that opens when VBA prompts user to select a file.  First you need to change to the Drive where the folder is stored. Below example is using X: drive location. Then change directory to the folder you want to open for the user.

ChDrive "X:\"
ChDir "X:\Data\Dev\Files"