M
M&M
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
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