Hi Jenny,

In terms of books, The Wrox "Excel 2003 VBA Programmer's Reference"
(http://www.wrox.com/WileyCDA/WroxTit...764556606.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