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

i.e one that list the various "codes" 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 & 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 Master


"Rich Mcc" wrote:

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

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

and ideal would be apreciated

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)

"Rich Mcc" (no spam) wrote in message
...
am looking for a vba refrence book .. rather than a idiots guide ..

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

and ideal would be apreciated

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

"Chris Marlow" wrote in message
...
Hi,

I'm not trying to be funny but have you tried using help? I accept that it
is not big and papery & 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 Master


"Rich Mcc" wrote:

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

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

and ideal would be apreciated

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 Master


"Bob Phillips" wrote:

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

"Chris Marlow" wrote in message
...
Hi,

I'm not trying to be funny but have you tried using help? I accept that it
is not big and papery & 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 Master


"Rich Mcc" wrote:

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

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

and ideal would be apreciated

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 <g, so he can go and take his own view.

Regards

Bob

"Chris Marlow" wrote in message
...
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 Master


"Bob Phillips" wrote:

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

"Chris Marlow" wrote in message
...
Hi,

I'm not trying to be funny but have you tried using help? I accept
that it
is not big and papery & 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 Master


"Rich Mcc" wrote:

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

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

and ideal would be apreciated

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 you


"Bob Phillips" wrote:

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)

"Rich Mcc" (no spam) wrote in message
...
am looking for a vba refrence book .. rather than a idiots guide ..

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

and ideal would be apreciated