software

am looking for a vba refrence book .. rather than a idiots guide ..

i.e one that list the various quot;codesquot; and what their options are,, rather
than a set of pre built programs

and ideal would be apreciated
Hi,

I'm not trying to be funny but have you tried using help? I accept that it
is not big and papery amp; you can't read it on the bus, but if you have a
printer to hand ...

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Masterquot;Rich Mccquot; wrote:

gt; am looking for a vba refrence book .. rather than a idiots guide ..
gt;
gt; i.e one that list the various quot;codesquot; and what their options are,, rather
gt; than a set of pre built programs
gt;
gt; and ideal would be apreciated
gt;
gt;

Take a look at the VBA 2002 Programmers Reference. Here is what I once wrote
about it

Synopsis This book presents a full reference to the Excel object model,
which is essentially the object-oriented system of organizing the functional
capacities that make up the Excel program. There is a short introduction to
VBA itself, and the rest of the book documents aspects of programming Excel
through that object model.

Level: Intermediate/Advanced

My view: The only 'Excel' book in the list. In my view there are not many
good Excel books around, too many re-hash the same old stuff which most
intelligent Excel users are perfectly capable of acquiring from their own
skills. But this one goes beyond all of that, it's about programming. I
often say to people that VB is easy, it's understanding the various object
models that is difficult and where the power lies. This book takes you
through the Excel object model, and show you many great techniques to
harness it for your code. The Object Model Reference is quite handy too!

Be careful to get the 2002 version though, maybe from eBay. There is a 2003
edit, but that was very poorly done IMO, and makes it less useful than its
predecessor.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Rich Mccquot; (no spam)gt; wrote in message
...
gt; am looking for a vba refrence book .. rather than a idiots guide ..
gt;
gt; i.e one that list the various quot;codesquot; and what their options are,, rather
gt; than a set of pre built programs
gt;
gt; and ideal would be apreciated
gt;
gt;
No disrespect Chris, but you have to be joking. It is 'okayish' to look up
individual questions, but it is not structured as a good book is, and
doesn't put the object model into context, unless you go down a hugely
onerous object model tree.

Bob

quot;Chris Marlowquot; gt; wrote in message
...
gt; Hi,
gt;
gt; I'm not trying to be funny but have you tried using help? I accept that it
gt; is not big and papery amp; you can't read it on the bus, but if you have a
gt; printer to hand ...
gt;
gt; Regards,
gt;
gt; Chris.
gt;
gt; --
gt; Chris Marlow
gt; MCSD.NET, Microsoft Office XP Master
gt;
gt;
gt; quot;Rich Mccquot; wrote:
gt;
gt; gt; am looking for a vba refrence book .. rather than a idiots guide ..
gt; gt;
gt; gt; i.e one that list the various quot;codesquot; and what their options are,,
rather
gt; gt; than a set of pre built programs
gt; gt;
gt; gt; and ideal would be apreciated
gt; gt;
gt; gt;
Bob,

No disrespect taken.

However I read what Rich wanted as specifics on certain bits of syntax
'rather than a set of prebuilt programs'. The book you refer to may well
provide this, however so does help (yes albeit without the fluffy stuff, and
I accept over time I've found some of it incomprehensible).

Fundamentally you learn over time by using not by reading books (on the bus
or otherwise). Help is integrated into the product, 'F1' and you get
something, why not use it? (And no I don't work for Microsoft ...)

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Masterquot;Bob Phillipsquot; wrote:

gt; No disrespect Chris, but you have to be joking. It is 'okayish' to look up
gt; individual questions, but it is not structured as a good book is, and
gt; doesn't put the object model into context, unless you go down a hugely
gt; onerous object model tree.
gt;
gt; Bob
gt;
gt; quot;Chris Marlowquot; gt; wrote in message
gt; ...
gt; gt; Hi,
gt; gt;
gt; gt; I'm not trying to be funny but have you tried using help? I accept that it
gt; gt; is not big and papery amp; you can't read it on the bus, but if you have a
gt; gt; printer to hand ...
gt; gt;
gt; gt; Regards,
gt; gt;
gt; gt; Chris.
gt; gt;
gt; gt; --
gt; gt; Chris Marlow
gt; gt; MCSD.NET, Microsoft Office XP Master
gt; gt;
gt; gt;
gt; gt; quot;Rich Mccquot; wrote:
gt; gt;
gt; gt; gt; am looking for a vba refrence book .. rather than a idiots guide ..
gt; gt; gt;
gt; gt; gt; i.e one that list the various quot;codesquot; and what their options are,,
gt; rather
gt; gt; gt; than a set of pre built programs
gt; gt; gt;
gt; gt; gt; and ideal would be apreciated
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;

Chris,

I take all your points, but when I started using VBA (coming from VB, so it
was not syntax help I needed but help with the OM), I found a book the
quickest way to get going. Now that I am more comfortable I agree I rarely
if ever use that book, and Help or Google is my reference.

Anyway, the OP has two view now lt;ggt;, so he can go and take his own view.

Regards

Bob

quot;Chris Marlowquot; gt; wrote in message
...
gt; Bob,
gt;
gt; No disrespect taken.
gt;
gt; However I read what Rich wanted as specifics on certain bits of syntax
gt; 'rather than a set of prebuilt programs'. The book you refer to may well
gt; provide this, however so does help (yes albeit without the fluffy stuff,
and
gt; I accept over time I've found some of it incomprehensible).
gt;
gt; Fundamentally you learn over time by using not by reading books (on the
bus
gt; or otherwise). Help is integrated into the product, 'F1' and you get
gt; something, why not use it? (And no I don't work for Microsoft ...)
gt;
gt; Regards,
gt;
gt; Chris.
gt;
gt; --
gt; Chris Marlow
gt; MCSD.NET, Microsoft Office XP Master
gt;
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; No disrespect Chris, but you have to be joking. It is 'okayish' to look
up
gt; gt; individual questions, but it is not structured as a good book is, and
gt; gt; doesn't put the object model into context, unless you go down a hugely
gt; gt; onerous object model tree.
gt; gt;
gt; gt; Bob
gt; gt;
gt; gt; quot;Chris Marlowquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Hi,
gt; gt; gt;
gt; gt; gt; I'm not trying to be funny but have you tried using help? I accept
that it
gt; gt; gt; is not big and papery amp; you can't read it on the bus, but if you have
a
gt; gt; gt; printer to hand ...
gt; gt; gt;
gt; gt; gt; Regards,
gt; gt; gt;
gt; gt; gt; Chris.
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Chris Marlow
gt; gt; gt; MCSD.NET, Microsoft Office XP Master
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Rich Mccquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; am looking for a vba refrence book .. rather than a idiots guide ..
gt; gt; gt; gt;
gt; gt; gt; gt; i.e one that list the various quot;codesquot; and what their options are,,
gt; gt; rather
gt; gt; gt; gt; than a set of pre built programs
gt; gt; gt; gt;
gt; gt; gt; gt; and ideal would be apreciated
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;
thanks for both of your comments,,, however i have to agree more with bob
that the help files arnt really much use to me at the moment,, id do use them
as a refrence sometimes but in general im better of with the refrence guide
which will tell me what things can do,, rather than how to make them do it

thanks to both of youquot;Bob Phillipsquot; wrote:

gt; Take a look at the VBA 2002 Programmers Reference. Here is what I once wrote
gt; about it
gt;
gt; Synopsis This book presents a full reference to the Excel object model,
gt; which is essentially the object-oriented system of organizing the functional
gt; capacities that make up the Excel program. There is a short introduction to
gt; VBA itself, and the rest of the book documents aspects of programming Excel
gt; through that object model.
gt;
gt; Level: Intermediate/Advanced
gt;
gt; My view: The only 'Excel' book in the list. In my view there are not many
gt; good Excel books around, too many re-hash the same old stuff which most
gt; intelligent Excel users are perfectly capable of acquiring from their own
gt; skills. But this one goes beyond all of that, it's about programming. I
gt; often say to people that VB is easy, it's understanding the various object
gt; models that is difficult and where the power lies. This book takes you
gt; through the Excel object model, and show you many great techniques to
gt; harness it for your code. The Object Model Reference is quite handy too!
gt;
gt; Be careful to get the 2002 version though, maybe from eBay. There is a 2003
gt; edit, but that was very poorly done IMO, and makes it less useful than its
gt; predecessor.
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Rich Mccquot; (no spam)gt; wrote in message
gt; ...
gt; gt; am looking for a vba refrence book .. rather than a idiots guide ..
gt; gt;
gt; gt; i.e one that list the various quot;codesquot; and what their options are,, rather
gt; gt; than a set of pre built programs
gt; gt;
gt; gt; and ideal would be apreciated
gt; gt;
gt; gt;
gt;
gt;
gt;