I developed a macro that writes a text file from excel to notepad.
The data in it needs to be displayed in the text file in a formatted way.

I am using the print command, however this prints my each cell of data in a
vertical
list. I need it to print this to the text file in a horizontal line. EXample:
Instead of:

DATA1
DATA2
DATA3
DATA4

I need:
DATA1, DATA2, DATA3, DATA4



Any Ideas?????????????????Highly appreciated

Hi,

You must transpose the data before printing to the Notepad application.

Challa Prabhu

"M&M" wrote:

I developed a macro that writes a text file from excel to notepad.
The data in it needs to be displayed in the text file in a formatted way.

I am using the print command, however this prints my each cell of data in a
vertical
list. I need it to print this to the text file in a horizontal line. EXample:
Instead of:

DATA1
DATA2
DATA3
DATA4

I need:
DATA1, DATA2, DATA3, DATA4



Any Ideas?????????????????Highly appreciated