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

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.

--
Regards,
Tom Ogilvy


"JBYoung" wrote:

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

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

"Tom Ogilvy" wrote:

> 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.
>
> --
> Regards,
> Tom Ogilvy
>
>
> "JBYoung" wrote:
>
> > 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
> >

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.

--
Regards,
Tom Ogilvy


"JBYoung" wrote:

> 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
>
> "Tom Ogilvy" wrote:
>
> > 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.
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> >
> > "JBYoung" wrote:
> >
> > > 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
> > >