Writing Excel Macros with VBA and over 2 million other books are available for Amazon Kindle . Learn more
£25.17
  • RRP: £26.50
  • You Save: £1.33 (5%)
FREE Delivery in the UK.
Only 3 left in stock (more on the way).
Dispatched from and sold by Amazon.
Gift-wrap available.
Quantity:1
Writing Excel Macros with... has been added to your Basket
Trade in your item
Get a £0.49
Gift Card.
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

Writing Excel Macros with VBA Paperback – 5 Jul 2002

3 customer reviews

See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle Edition
"Please retry"
Paperback
"Please retry"
£25.17
£14.52 £3.71
£25.17 FREE Delivery in the UK. Only 3 left in stock (more on the way). Dispatched from and sold by Amazon. Gift-wrap available.

Frequently Bought Together

Writing Excel Macros with VBA + VB & VBA in a Nutshell: The Language: The Languages (In a Nutshell (O'Reilly))
Price For Both: £51.67

Buy the selected items together


Trade In this Item for up to £0.49
Trade in Writing Excel Macros with VBA for an Amazon Gift Card of up to £0.49, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Product details

  • Paperback: 574 pages
  • Publisher: O'Reilly Media; 2 edition (5 July 2002)
  • Language: English
  • ISBN-10: 9780596003593
  • ISBN-13: 978-0596003593
  • ASIN: 0596003595
  • Product Dimensions: 17.8 x 2.7 x 23.3 cm
  • Average Customer Review: 4.3 out of 5 stars  See all reviews (3 customer reviews)
  • Amazon Bestsellers Rank: 172,579 in Books (See Top 100 in Books)
  • See Complete Table of Contents

Product Description

Review

'Writing Excel Macros' is definitely the place to begin to when you're ready to delve into macros. Strongly recommended." -- James E. Powell, The Office Letter, September 2002

From the Publisher

To achieve the maximum control and flexibility from Microsoft® Excel™ often requires careful custom programming using the VBA (Visual Basic for Applications) language. Writing Excel Macros with VBA, 2nd Edition offers a solid introduction to writing VBA macros and programs, and will show you how to get more power at the programming level: focusing on programming languages, the Visual Basic Editor, handling code, and the Excel object model.

Inside This Book

(Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

4.3 out of 5 stars
5 star
2
4 star
0
3 star
1
2 star
0
1 star
0
See all 3 customer reviews
Share your thoughts with other customers

Most Helpful Customer Reviews

7 of 7 people found the following review helpful By Laura Graham-Brown on 14 Sept. 2005
Format: Paperback
As a professional trainer this is a book I highly recommend to delegates. Not only covers the Excel specific parts of VBA but also covers the general principles and good practice techniques of programming.
Good examples, clear explanations, a good book to support anyone learning VBA.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
26 of 28 people found the following review helpful By Gavin on 24 April 2003
Format: Paperback
I was attracted by the author's 'terse' style and comprehensive approach. The concept of breaking VBA down into its core components and laying these out for the reader is great. [ie as compared to going through standard basic VBA apps]. In practice though I found this rather unfathomable. I've used this book during my [rather painful] VBA initiation period and found it ranging from almost impossible to understand [at the start] to potentially helpful and quite comprehensive for those aspects that I've not seen covered elsewhere [4 months later]. I do think it promises a lot but because its objective is to really delve into how vba works, it doesn't quite bridge the gap between vba environment and applications. I constantly refer to it but find it difficult to extract much detailed information, although i am finding more and more 'titbits' which make sense. I think one day it will all open up and reveal its treasures to me, but on the other hand, it may never make much sense. In the meantime, I've had to buy another VBA book which focuses more on the apps side.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
8 of 9 people found the following review helpful By S. Tokumine on 28 May 2004
Format: Paperback
Well, other reviewers have said it's a hard book to get to grips with. Whilst this is probably true if you have little/no programming experience at all, for those of us who do and who dont want to wade through massive chapters on "what is a variable" again, this book is a godsend. With a background in OO languages, I found I could just pick this book up, and get coding pretty much straight away. It is concise, but that's a good thing i think, and is generally par for the course with O'Reilly who do tend to target the experienced coder.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Helpful Customer Reviews on Amazon.com (beta)

Amazon.com: 29 reviews
21 of 21 people found the following review helpful
Mr Roman's book is very good value. 16 May 2005
By Douglas L. Brasier - Published on Amazon.com
Format: Paperback Verified Purchase
Mr Roman is an extremely competent and clear writer. This book, whilst not as big as some, doesn't waste space with any padding, and boring repititious stuff you see in some texts.

Although there could have been a little more on interplay between Excel and the other Office objects, esp. Outlook, this book makes up for that with its clear, organised and logical presenatation.

I use it as a reference book, and seem to remember the content of it more clearly than I do with other comparable books! Why is this? Mr Roman has a tidy turn of phrase, doesn't wafffle, but his explanations seem to sit well in how my mind works. I hope this will be the same for you.

I recommend this book for those who may be beyond the beginner stage of learning VB(A). It also includes some handy utilities for users of Excel.

Mr Roman - well done. Look forward to your next (high level?) Excel VBA book.
23 of 24 people found the following review helpful
Good Reference 7 Jun. 2005
By Dan McKinnon - Published on Amazon.com
Format: Paperback
This is a very specialized book with a very specialized core audience and this text does what it says it does -- teach you how to write Excel Macros using VBA. Nothing too exciting here folks, very dry reading that is a necessary reference if you need to have more control over Excel than the everyday user does.

I remember long ago when I needed to work on building some installers and I had never worked with Installshield before. There was one book on the market that was helpful in completing this task, and there is a very close correlation here as well. There simply is not enough of a market to provide a wide variety of different books to choose from when needing to learn how to write Excel macros. Any user would want a book that helps them complete their task at hand and this book gets my seal of approval in helping to do just that.

**** RECOMMENDED
46 of 53 people found the following review helpful
Only mathematician can write this book 30 July 2002
By Weiqin Xie - Published on Amazon.com
Format: Paperback
I don't know why this book is labeled as "2nd Edition". The cover is the 3rd "face" I have seen. I did learn good stuff from the previous editions, but never recommend it to anybody for its' dry. The new edition has a big change. It is succinct, reader-freindly, but also contains many useful information you won't find in other books. For instance, there is no any other book goes so depth into Pivot Table properties and methods. Comparing with the Excel 2002 VBA books written by John Walkenbach or Stephen Bullen and John Green, this book definitely presents more real 2002 features. If you want to learn more about Excel 2002 objects, get this book.
12 of 12 people found the following review helpful
Among the best books on Excel VBA 6 July 2006
By K. Scott Proctor - Published on Amazon.com
Format: Paperback
"Writing Excel Macros with VBA" is an excellent book on the use of VBA (Visual Basic for Applications) for Microsoft Excel. Steven Roman provides a significant amount of information in a relatively short volume.

While this book is accessible to Excel users of a variety of skill levels, it is best suited to numerically-inclined and experienced users of Excel. The book offers a good introduction to the VBA programming environment and the Excel object model.

Steven Roman has written the best book on Excel VBA that I have read to date.
26 of 30 people found the following review helpful
Not a good primary reference 14 Sept. 2004
By Will Golson - Published on Amazon.com
Format: Paperback
I was looking for a primary reference for the Excel object model. I have years of programming experience, some VB, and was looking for something to get me started programming Excel VBA. This book is not suitable as a primary reference. Much better are either Power Programming (Walkenbach) or Excel VBA (Bovey) which contain many useful tips and gotchas that helped me out of a few baffling situations. Roman's book seemed to focus on the few examples he developed, rather than be a resource for problems a beginning/intermediate Excel programmer was likely to encounter.
Were these reviews helpful? Let us know


Feedback