Hi there guys!

I will appreciate everybody’s input to help me solve this task.

Here is what I basically want to do:

I have an Excel Spreadsheet report with figures on it in the following format:


R00030 15 4 6 2 17
R00033 6 0 5 0 1
R00035 16 29 18 20 19

What I basically need to do is

1. Read the excel file from a VB application
2. Do the format conversion to look like this

R00030 15
R00030 4
R00030 6
R00030 2
R00030 17

How do I read an excel spreadsheet from VB?

Thanks,
Ryno