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"
