Marcster
10-03-2005, 08:20 AM
Hello People :hi: ,
I have data in an Excel file as shown below:
01-23-45 John Smith 02345678 123.10 Reference 99
65-43-21 Joe Bloggs 87654320 1245.10 Reference 99
What I want to be able to do is, save the above information
to a text file without an extension to the same place as the workbook.
The file name should be the uk date. i.e. for today: 031005
When that file is opened in notepad the contents should look like:
"01-23-45","John Smith","02345678","123.10","Reference","99"
"65-43-21","Joe Bloggs","87654320","1245.10","Reference","99"
Like a .CSV file but with " before and after the data in the columns.
The data rows will vary in length. :help
Is there a macro to do this please?. :think: .
Thanks,
Marcster.
I have data in an Excel file as shown below:
01-23-45 John Smith 02345678 123.10 Reference 99
65-43-21 Joe Bloggs 87654320 1245.10 Reference 99
What I want to be able to do is, save the above information
to a text file without an extension to the same place as the workbook.
The file name should be the uk date. i.e. for today: 031005
When that file is opened in notepad the contents should look like:
"01-23-45","John Smith","02345678","123.10","Reference","99"
"65-43-21","Joe Bloggs","87654320","1245.10","Reference","99"
Like a .CSV file but with " before and after the data in the columns.
The data rows will vary in length. :help
Is there a macro to do this please?. :think: .
Thanks,
Marcster.