Merge Two Spreadsheets into 1 new sheet...
 

Hi,

Have never done vba/excel programming. Didn't know exactly what to search
for. Been using vb6 for 7 years so vba won't be totally foreign if that is
what is
required. If I can use C# even better. Anyway...

I have a client who has asked me to write a program for them that would
take the data in two different Excel spreadsheets, apply some metrics and
then
save it into a new spreadsheet containing elements of both sheets. I need
to be
able to:

1. Open sheet 1 as read only.
2. Open sheet 3 as new sheet with write permissions.
3. Loop through every cell in sheet 1, test each value, on pass condition
copy
value to specific cell in sheet 3.
4. When sheet 1 is fully processed close sheet 1 and open sheet 2.
5. Perform same thing in sheet 2 as sheet 1 and then search sheet 3 and place
related data into specific row.
6. Close sheet 2.
7. Save sheet 3 as new sheet that his merged from sheet 1 and 2.

Now I'm not looking for someone to write the program. What I am wondering
is do I use VB to do this, VBA from within Excel? What's the best approach
and
then for some brief samples that illustrate how to do this. My google searches

all returned empty so I am hoping someone here has an idea.

Thanks,

Rex Winn