I'm new to VB, but have had programming experience in other languages
(many years ago).

I'm looking for a sample program that I can use to:
a) open and read an excel worksheet, row by row
b) accumulate totals in an array based on the data in the row as wel
as some input parameters.
c) when all the rows are processed, create a new worksheet with data
from the array.

I'm sure this is about as basic as a VB program can be and that there
are web sites with sample programs but need help locating them. Or
perhaps there is a book I can buy.

Thanks for any help.

In Google or whatever browser you have, type "Excel MVP" or something that
relates to "Excel VBA" and take your pick. Some of the guys on here have
their own websites with loads of very useful examples of common issues with
VBA that myself have been a superb learning tool.

John


"Harry" wrote:

I'm new to VB, but have had programming experience in other languages
(many years ago).

I'm looking for a sample program that I can use to:
a) open and read an excel worksheet, row by row
b) accumulate totals in an array based on the data in the row as wel
as some input parameters.
c) when all the rows are processed, create a new worksheet with data
from the array.

I'm sure this is about as basic as a VB program can be and that there
are web sites with sample programs but need help locating them. Or
perhaps there is a book I can buy.

Thanks for any help.

Start with http://www.mvps.org/dmcritchie/excel/getstarted.htm

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Harry" wrote in message
...
I'm new to VB, but have had programming experience in other languages
(many years ago).

I'm looking for a sample program that I can use to:
a) open and read an excel worksheet, row by row
b) accumulate totals in an array based on the data in the row as wel
as some input parameters.
c) when all the rows are processed, create a new worksheet with data
from the array.

I'm sure this is about as basic as a VB program can be and that there
are web sites with sample programs but need help locating them. Or
perhaps there is a book I can buy.

Thanks for any help.