Best resource for VB/Excel programming

[Ato_zee]

I've finally cracked getting VB to run, and then open
and close text files. Plus do a few basic things.

I've an Excel spreadsheet with 5000 upwards names,
A1 to A5047 and an input.txt file with about 150
names (on a regular basis). Currently I look up
each name in Excel's find, to get the matching
Excel cell number. For 150 names this takes ages.

The output file should still be .txt with the names
followed by the looked up Excel cell number.

Is there a book or online resource that covers
using VB with Excel?

I'm ok with programming in GWBasic, Fortran,
PL/1 (is it still around?), but new to VB6, once I
get some pointers in the right direction I should
be ok.

[gswork]

Post by Ato_zee
I've finally cracked getting VB to run, and then open
and close text files. Plus do a few basic things.
I've an Excel spreadsheet with 5000 upwards names,
A1 to A5047 and an input.txt file with about 150
names (on a regular basis). Currently I look up
each name in Excel's find, to get the matching
Excel cell number. For 150 names this takes ages.
The output file should still be .txt with the names
followed by the looked up Excel cell number.
Is there a book or online resource that covers
using VB with Excel?
I'm ok with programming in GWBasic, Fortran,
PL/1 (is it still around?), but new to VB6, once I
get some pointers in the right direction I should
be ok.

www.mvps.org

is a nice starting resource, one of the sections has an online book
for vb and a couple of sites for Excel VBA (which is what will help
you with the above)