Hi !
According to forum rules you must use the code tags ! Please take a moment to add the tags.
Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing and it also maintains VBA formatting.
Please see
Forum Rule #2 about code tags and adjust accordingly.
Click on Edit to open your post, then highlight your code and click the
# icon at the top of your post window.
More information about these and other tags can be found
here.
To create a directory use
MakeSureDirectoryPathExists …
Bookmarks