Excel 2003/VBA book recommendation

[Ron Nolan]

I'm looking for recommendations on a good Excel automation book,
specifically regarding Excel VBA and ADO. Here's what I'm going to do:

I have users here that have an excel 2003 workbook with 2 sheets.
Sheet 1 is a pivot table based on Sheet 2, which is raw data. Column A
of Sheet 2 contains Job IDs, no more than a few hundred of them.

I want to write a VBA macro that will iterate through each Job ID in
that list and pass it to a SQL Server Stored Procedure as a Parameter,
and if any data is returned to place that information onto their data
sheet.

Any recommendations would be welcome.

Thanks.

 

[Harald Staff]

Hi

I don't think you'll find an Excel VBA book that goes into this in-depth.
But VBA is VB6 with only a different set of objects, so give this one a try:
http://tinyurl.com/2lmuj