Hi John,
Thank you very much for your recomemdations for books and
useful websites. I appreciate your help very much.
Jenny

-----Original Message-----
Hi Jenny,

In terms of books, The Wrox "Excel 2003 VBA Programmer's
Reference"
(http://www.wrox.com/WileyCDA/WroxTitle/productCd-
0764556606.html) is very
good, well at least the 2002 version was anyway (and it
has a specific
chapter on Charts).

For general web info, I've found the following to be
good sources:

http://www.mrexcel.com/ (also has book, although I've
not read it myself)

http://j-walk.com/ss/excel/tips/index.htm (excellent
site, full of example
code), plus several books by him
(http://www.j-walk.com/ss/books/xlbook25.htm again, I
haven't read it but it
looks pretty comprehensive.)

and lastly, David McRitchie's site
http://www.mvps.org/dmcritchie/excel....htm#tutorials
also has a lot of
good stuff on it including a much more comprehensive
list of links than the
one here!

Anyway, hope that helps.

Best regards

John




"Jenny G." wrote
in message
...
Hi Everyone,
I've worked with Access programing for a while, but
now I
need to use Excel VBA to automate some data analysis
with
some charts on the report. I am not sure where to
start.
Can anyone suggest what book I should buy to get the
Excel programing knowledge? Or is there any Excel
automation examples that I can learn from? Thanks for
any
suggestions?
Jenny


.