excel 2003 vba
I have data in a workbook "MyWork.xls"
All my important information is on "Sheet1"
Column Headers A1:AU1
I need a vba sub routine that from a command button.
1. Will save the sheet to txt pipe delimited file to a folder called
2. a NEW txt file needs to be created each time a person clicks the button.
"<nameofworkbook & DateTime>.txt"
So at the end of the day , if a person clicked the button 6 times...the folder would contain 6 txt files...
3. incude empty rows and empty cells in range