countdown boutiques-francophones Learn more vpcflyout Home All-New Kindle Music Deals Store sports Tools

Customer Reviews

3.1 out of 5 stars
3.1 out of 5 stars
Format: Paperback|Change
Price:$36.01+ Free shipping with Amazon Prime
Your rating(Clear)Rate this item

There was a problem filtering reviews right now. Please try again later.

Showing 1-3 of 3 reviews(4 star). Show all reviews
on June 13, 2003
As someone who has some programming experience, this book was very helpful to me.
The project I am working on was already defined, and all I had to do was look in the books where an example was given or a syntax reference existed. Note that I used it in alongside Walkenbach's Excel 2002 Power Programming with VBA. Where certain areas aren't covered in this book (as it's only 500 pages), there will almost ceratinly be something in the other.

As an intermediate level part-time programmer (mostly self-taught) of Java, C, Javascript, HTML, CSS, XML, Assembly and others, this book certainly had what I was looking for.
It mainly offers concise language references and the descriptions are kept to the necessary, and this O'Reilly book is a vast improvement on some that I have bought for other languages in the past.
It does however assume some prior knowledge of programming techniques, and is therefore not for the beginner.
I would recommend THIS book only to those who have either a very keen interest in programming or those who have had some formal programming teaching. Definatly worth the money though.
0Comment|Was this review helpful to you?YesNoReport abuse
on April 5, 2004
Thanks for the reply. I was originally looknig for some online documentation, and was hoping I could find some, but came up sadly empty-handed.
So last week I went to my local B&N and picked up exactly that book, "Writing Excel Macros with VBA 2nd edition," by Steven Roman (O'Reilly).
Now it should be noted that the book was not writen around my purpose. I am looking at programmatically controlling Excel objects from within the VB programming environment (Vis Stud 6 and ASP). However, this book seems to have been written for someone who wants to program VBA from within Excel.
I took a chance and got the book anyway and, thankfully, the objects I need to work with are decently documented. I don't give my highest praises to the book on documenting the Excel Objects, but it is clearly not the fault of the author, Steven Roman. From reading the book it is clear he had little in the way of docs to work with when compiling his material. To his credit he falls short of throwing up his arms in depair, but quotes like:
"Unfortunately, neither of these methods is sufficiently documented, so some experimentation is in order."
are peppered throughout the book (I have not read the whole book, just the latter half concerning the Excel object documentation).
I am hoping this book gives me what I need.
0Comment| One person found this helpful. Was this review helpful to you?YesNoReport abuse
TOP 1000 REVIEWERon January 10, 2004
OK... I can hear it now... What are we doing reviewing Microsoft application books in a Notes/Domino context? Trust me, it actually makes sense here. Read on...
This book is a refreshing change from the 1000+ page manuals you often see when you are looking for a technical reference book. The author's philosophy is such that he doesn't resort to handholding, nor does he try to explain every last nuance of an application. Instead, he gives a concise explanation of the material, and builds upon the information as you go. When you are done with the material, you should have the basic knowledge you need to be productive immediately, as well as the tools you need to delve further into VBA and Excel programming.
The first part of the book shows you the editing environment used to program Excel. Once you have that down, he explains the basics of VBA. VBA, or Visual Basic For Applications, is a subset of the Visual Basic language, and is well suited for scripting activities within an application object model. Once you understand all that, you start putting that newly acquired information to work by creating Excel applications that allow you to automate functions within Excel.
OK, now back to the Notes/Domino world. Why do you need to know anything about Excel and how to program it? It depends if you want to really want to extend the power of Notes. With LotusScript, you can create an Excel object in code using COM technology. Once you have the Excel object declared, you could use LotusScript to start manipulating the properties and methods of all the Excel objects. So for instance, you could build an agent that would read all the documents in a view and create a simple Excel spreadsheet without having the user work through the cumbersome view export menu option. Or to be more impressive, you could use the Excel object model within LotusScript to create monthly reports with all the formatting you would normally do manually within Excel. This keeps the user from having to manually transfer data from one application to another.
So why this book? To effectively program LotusScript and Excel, you MUST understand the object model of the application. If you don't understand the object hierarchy of Excel, it makes it nearly impossible to do anything more than the simplest of tasks. The author does a great job of explaining the different objects in Part 3 of the book. While not all of the objects are applicable to your Notes/Domino programming, most of the material will give you the information you need to understand where to start and to figure out what is possible.
I recommend this book to any Notes/Domino developer who wants to create applications that interface with Excel. Other books concentrate too much on how to work with Excel as an application. This book gives you the tools you need to work with Excel as a programmable tool.
0Comment| One person found this helpful. Was this review helpful to you?YesNoReport abuse