how to compare .xls to .csv in vb6

Question

0.00/5 (No votes)

See more:

Hi!
Can anyone help me with my project?
I need to create a program where in I need to compare the invoice# in .xls and in .csv file. In the .xls there are 3 column (customer number, invoice#, date sent) and in .csv there are 10 columns (no header), the invoice# in .csv is located in 3rd column and the status of each invoice is in 2nd column. I need to compare and show the status of each invoice in the .xls file 5th column (in .csv) if the status is 1 means accepted, 2- processed, 3- collected.

I only started the interface where in I have 2 text boxes (1st text box for .xls and 2nd for .csv), and I added a command button so if I click this the process will start.

I don't know how to start the main process, please help me.
Thanks a lot

Posted 19-Jun-11 20:43pm

an@lyn

Updated 20-Jun-11 0:08am

Nagy Vilmos

v2

Add a Solution

Comments

Nagy Vilmos 20-Jun-11 6:08am

Edited so that I can read it.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Nagy Vilmos · Answer 1 · 2011-06-20T00:12:00

Solution 1

[edit for poor reading - thanks Carlo]

Try this[^] for Excel.

~~This[^] mauy help you in reading in the XML~~ and this[^] should help you reading the CSV.

Define a class that combines the data from both files.
Load the data into instances of the class.
Now process the class instances rather than the raw data.

Posted 20-Jun-11 0:12am

Nagy Vilmos

Updated 20-Jun-11 0:42am

v2

Comments

CPallini 20-Jun-11 6:39am

XML?!
:-)

Nagy Vilmos 20-Jun-11 6:42am

Me bad, no read well pre-espresso.

CPallini 20-Jun-11 6:51am

My 5.

an@lyn · Answer 2 · 2011-06-23T18:13:00

Solution 2

hi,

can you give me sample code on how to do this? thanks.

Posted 23-Jun-11 18:13pm

an@lyn

Comments

Christian Graus 24-Jun-11 0:24am

Please don't push 'answer' to make a comment. Why can't you read the articles and write your own code ? If you can't write code at all, then you should go to the jobs board and hire someone to do this for you, but, given that you're using VB6, which is both a dead language, and horrible, I think you'll find that the few people still lowering themselves to using it, will charge a lot for having to do so. Why on earth are you not using .NET ? If you can't write your own code based on the links given, I assume you're an absolute beginner, writing code for fun and not being paid for it. What on earth could be fun about VB6 ?