vba to copy column data from excel to notepad and separate data with semi colons?

Thanks Marc L! I apologize for my ignorance, but once I place this code in a module and run it, what do I do next? Do I need to go to a certain directory, or just do a paste, etc. Really appreciate your help!