Hi There! What I am looking to do is create folders based on cell values and save a text file created from other cell values into those folders. Currently, I have 2 sets of code that are assigned to 2 buttons to execute these codes. The code for the folders works great. The code for the text works well also, but I have to navigate to the folder I created in order to save the text file. Is it either possible to combine the codes or alter the code for the save text to save the text to the previously created folders? Also, I am creating text on multiple rows - so sometimes I am creating several text files and each time I have to save to a different location. I'd love to have one piece of code I could assign to a button that would save text files to the folders and only text files where there is text present. I hope this all makes sense. I am currently trying to solve this on my own but I'm stumped.

Any and all help is greatly appreciated. Thank you!

CODE FOR CREATING FOLDERS
Please Login or Register  to view this content.


CODE FOR SAVING TEXT FILES (ONE ROW)
Please Login or Register  to view this content.