Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
import csv data in excel using vb
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
import XML data...Is there a size limit on the import? | Excel Discussion (Misc queries) | |||
How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
Import external data, data includes Excel function | Excel Worksheet Functions | |||
PLEASE!! How can I un-grey the 'Data-Import External Data-Import Data' option ??? | Excel Programming | |||
how to Import data in excel office2003 with data more 65000 rows | Excel Worksheet Functions |