macro 2 save all cells w/data 2 TabDelimited

Microsoft Excel 2003 (full product)
December 7, 2010 at 19:39:12
Specs: Windows XP
Hi and thanks in advance for any help you can provide.

I have a spreadsheet that currently populates data in column (AG) if the IF statements are true. Could be as few as 2-3 rows and up to as much as 4000 rows. I would like help in creating a button activated macro that can find all cells within the (AG) column that contains any data and then save that to a Text (Tab Delimited) file with the information separated by a pipe "|".

Ex:
"entry1"|"entry2"|"entry3"| etc....

Some additional requests would be to automatically save the tab delimited file to be what the original excel document name is then append it with the current date.

Ex: original excel spreadsheet name is "Expenses.xls"
Automatically saves it as "Expenses_YYYYMMDD.txt" with the abiliity to save the file to a local disk or file share.

Thanks again!
DCMan


See More: macro 2 save all cells w/data 2 TabDelimited

Report •

#1
December 10, 2010 at 07:06:00
then save that to a Text (Tab Delimited) file with the information separated by a pipe "|".
One of us is confused, but I'm pretty sure a "tab" is not a "pipe."

How To Ask Questions The Smart Way


Report •
Related Solutions


Ask Question