Please help,
when I change the name of directory on Sheets("Settings").Range("F4")
I get error directory is not exist, I need to create directory manual, below VBA is working if the directory not change,
it's possible to add vba if directory not exist wil be create automaticaly.
Thank you
Please Login or Register to view this content.
Last edited by kirana2014; 10-12-2023 at 12:58 PM.
(removed as I misread)
Last edited by Marc L; 10-12-2023 at 05:23 AM.
Have a try adding this line of code:Ps. Hi to all.Please Login or Register to view this content.
Difficult is not to know but to share what you know (Han Fei Tzu reworked)
Another solution.
MyMkDirFSO function can create a multiple nested folder structure (e.g. "D:\Test\a\b\c\d"). It can, of course, be used to create just one folder.
The OpslaanOverzichtalsPDF procedure has been modified to protect against invalid folder names (when using forbidden characters) or lack of permission to edit the folder.
ArtikPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks