Macro That Creates Text Doc in specific folder based on cell value

[stevedes7]

I need to create a macro that will look at a specific cell, and if it is filled, create a txt document with that cell name, in a specific folder.

For example, if A1 = "John Smith", the macro would create the file "John Smith.txt" in C:/Clients/

Further more, in an attempt to prevent deletion of an already created filed, it would need to first confirm there is no John Smith.txt already located in the folder, then create the file. If there already is a John Smith.txt, it would simply move on to A2, A3, A4, etc performing that same task, until all of column A's cells have corresponding txt files.

Thanks for your help guys.

[JBeaucaire]

Steve, drop a note to the Moderators (DonKeyOte, Teylyn, Davesexcel, NBVC) and ask them to move your post to the correct forum, the Programming forum.

========
As for the macro, you say "create a file named John Smith"...but you don't indicate what the content of that file should be. Sheet1? Sheet5? "Data"?

[stevedes7]

I want it to be a blank file. Literally just a 0 kb .txt file with the person's name, placed in a specified folder.

[JBeaucaire]

This should do it for you:

Please Login or Register  to view this content.

[DonkeyOte]

thread moved to Programming...