Basic Macro Question (Urgent!)

[Guest]

As a beginner, I am currently writing the VBA program. I have some problems,
hope you can help me to solve these problems:

1. I have a set of data in the worksheet which has 100 columns with about
200 rows. I want to make them all together by each row with comma between
each data.
2. After that, how can I convert it to csv.format
Many thanks

 

[Guest]

Excel can do that without any code

do file=>Saveas and for file type choose CSV.

if you need code, turn on the macro recorder while you do it manually.

 

[Guest]

Hi Tom,

Thanks.

However, as mentioned in question 1, how can I make a set of numbers
together by writing the macro? e.g., 123 123 123 = 123,123,123 and ensure it
will stop in the data end.

Regards,
JB

 

[Guest]

If you doing that to write a CSV file, again, you don't have to. Excel does
it for you.

If you want to do it the hard way:

http://www.cpearson.com/excel/imptext.htm

If you don't want to write a CSV file with the results, where do you want to
place the data? Adapt the code above to put it there.