Any good books?
 

Hi, Does anybody recomend any books on the subject, VBA Programming
with Excel 2003. With a reference to all the formula's and comands.

Thanks

Any good books?
 

Formulas/functions aren't VBA. If you want the object model, get Excel 2002
VBA Programmers Reference (Bullen, Bovey, Rosenberg, Green), avoid the 2003
version. If you want VBA methods, commands etc, get John Walkenbach's VBA
for Dummies, or maybe his VBA Power Programming if you think the Dummies
book is too basic.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Oggy" wrote in message
ups.com...
Hi, Does anybody recomend any books on the subject, VBA Programming
with Excel 2003. With a reference to all the formula's and comands.

Thanks

Any good books?
 

Bob has summed it up completely.

Take a look at the two sites books at:

John: http://j-walk.com/ss/
Stephen et al: http://www.oaltd.co.uk/

A couple mo

Debra Dalgleish: http://www.contextures.com/index.html (primarily pivot
tables)
Bill Jelen: http://www.mrexcel.com/

Some lessons at:
Gary Redley: http://users.bigpond.net.au/gradley/vbatutor/
Pan Pantziarka: http://www.techbookreport.com/tutorials/excel_vba1.html

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Bob Phillips" wrote:

Formulas/functions aren't VBA. If you want the object model, get Excel 2002
VBA Programmers Reference (Bullen, Bovey, Rosenberg, Green), avoid the 2003
version. If you want VBA methods, commands etc, get John Walkenbach's VBA
for Dummies, or maybe his VBA Power Programming if you think the Dummies
book is too basic.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Oggy" wrote in message
ups.com...
Hi, Does anybody recomend any books on the subject, VBA Programming
with Excel 2003. With a reference to all the formula's and comands.

Thanks

Any good books?
 

Ignore previous post it is to another reply.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Martin Fishlock" wrote:

See my comments on books in a few posts previous (Any good books?)

I also mention some lessons at:

Gary Redley: http://users.bigpond.net.au/gradley/vbatutor/
Pan Pantziarka: http://www.techbookreport.com/tutorials/excel_vba1.html

VBA is really the basic programming language with the MS object model for
excel/office on top to allow the GUI access.

Good luck.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Martin Fishlock" wrote:

Bob has summed it up completely.

Take a look at the two sites books at:

John: http://j-walk.com/ss/
Stephen et al: http://www.oaltd.co.uk/

A couple mo

Debra Dalgleish: http://www.contextures.com/index.html (primarily pivot
tables)
Bill Jelen: http://www.mrexcel.com/

Some lessons at:
Gary Redley: http://users.bigpond.net.au/gradley/vbatutor/
Pan Pantziarka: http://www.techbookreport.com/tutorials/excel_vba1.html

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Bob Phillips" wrote:

Formulas/functions aren't VBA. If you want the object model, get Excel 2002
VBA Programmers Reference (Bullen, Bovey, Rosenberg, Green), avoid the 2003
version. If you want VBA methods, commands etc, get John Walkenbach's VBA
for Dummies, or maybe his VBA Power Programming if you think the Dummies
book is too basic.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Oggy" wrote in message
ups.com...
Hi, Does anybody recomend any books on the subject, VBA Programming
with Excel 2003. With a reference to all the formula's and comands.

Thanks