Hi,

I am using the following code in VB6 to generate a CSV file that opens in MS EXCEL :

CODE :

Dim printLINE as String
Dim ctr as Integer
Open "c:\File1.CSV" For Output As #1
For ctr = 0 To 20
printLINE = printLINE & ctr & ","
next ctr
Print #1, printLINE

This generates a csv file by the name File1.csv with only one sheet by the name File1.

My question is that how can i have more that one sheet e.g. File1 & File2 within the same csv file File1.CSV?

Does any body have any idea ?

Arun