By using vba.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Step 334 - ChDir - Files

To change your default directory use

ChDir "directory name"

All file references afterwards don't have to reference the directory.

This does the same function as the Dos command cd command