Are you talking about accessing a Comma Delimited CSV file with VB6 reading in info and writing back to a CSV file or are you looking to make a VB Script macro to use within Excel itself?
Have you ever worked with VB before so that I/we can use terminology here and you'd be all set with it or should we describe everything in a greater detail in future posts to this thread?
Additionally is there a reason why your using VB6 which is almost 20 years old vs a newer VB IDE?