View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
s[_3_] s[_3_] is offline
external usenet poster
 
Posts: 1
Default import csv data in excel using vb

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