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"
[efb_likebox fanpage_url="https://www.facebook.com/vbamarket/" box_width="840" box_height=340"" responsive="1" show_faces="1" show_stream="1" hide_cover="1" small_header="0" hide_cta="0" locale="en_US"]