I need to put data from a csv file into an Excel worksheet.
File is called "DTN.csv" and the Excel file is "BlendPrice" and the workbook is "DTNPrice".
The DTN.csv file has 12 fields seperated by commas. (I have been copying and pasting the data in now. I need to automate this process to run at night.)
rclinebell
0
Newbie Poster
Recommended Answers
Jump to PostSeveral ways...
Several Questions...Do you want your program to run as a service?
Do you know how to open a file and read it in?
Do you know how to automate excel?
Do you know how to use excel like a database with ADO?
Do you know how …
Jump to PostOkay, so for now... you don't mind starting the program before you leave, right?
One step at a time...
First, do you know how to read the file in by using VB? If not please look these up in help
Open Statement
FreeFile Function
Input Function
Line …
All 5 Replies
vb5prgrmr
143
Posting Virtuoso
rclinebell
0
Newbie Poster
vb5prgrmr
143
Posting Virtuoso
rclinebell
0
Newbie Poster
vb5prgrmr
143
Posting Virtuoso
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.