import csv data in excel using vb

[s]

I need to import data from csv file to excel template through
vb6.Currently I'm
copying data from csv file and pasting it on excel template using copy
and
pastespecial methods of worksheet.Is there any other fastest or
easiest
method to accomplish this task through vb6 coding(or direct import
method which will do my
task little easier as csv file contains large amounts of data &
there are 5 csv files that I need to copy on 5 sheets of excel
template)
Any help or coding snippet regarding this is urgently needed

Thanks
-sd

 

[merjet]

Have you tried just using the macro recorder? Turn it on, do what you
usually do, then turn it off. It will generate code you can reuse with
only a couple of clicks.

Hth,
Merjet