This is the code I have used for years and now it does not work. The line starting with 'If Len...." seems to be an issue. I did not write this however found it on the web several years back. Any help would be greatly appreciated.
Please Login or Register to view this content.
Last edited by zbor; 12-26-2024 at 03:56 PM.
Welcome to the Forum cmunroe1015!
What does "it does not work" mean? What do you expect it to do, and what does it do instead?
What text is in the cells that you are looping through to create the folders?
The first thing I notice is that the code includes
which does absolutely nothing at all. It seems like you should havePlease Login or Register to view this content.
there, but without knowing more about your file I can't say for sure.Please Login or Register to view this content.
Also, we recommend that you include code tags around your code. 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. A Moderator has added them for you in your post.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
I am trying to create file folders from a list in excel. The text would be something like this "PROC-0005678 Business Management"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks