Rating: 
Summary: A for effort
Review: 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. Dave
Rating:
Summary: A for effort
Review: 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. Dave
Rating: 
Summary: The Title of the Book has Been Mistaken
Review: When I bought the book, I was impressed by its title and TOC since they give the promise of leading the reader into macro programming. However, it is rather a large-volume Excel/VBA reference, not a book on how to write macros.
Unfortunately, there is no system of introducing the reader gradually into the language (as in all usual programming textbooks) by introducing concepts, giving examples and requesting particular exercises. On a positive note, the book contains (all) VBA concepts relevant to Excel macros and can very well serve as a future reference once the reader has bought another book to learn how to code within some range of macro programming.
Rating:
Summary: Not helpful for an intermediate programmer
Review: When purchasing this book, I already had in mind the macros that I wanted to program and the logic I was going to use in order to accomplish the task. All I was really looking for was a breakdown of the syntax in VBA (I'm new to the language), and a list of commands that were available. Trying to extract this information from the book was tedious at best. It would have also been useful if there was an example or two of how some of the basic syntax works. I can only really use it as a second reference from the help menus already provided in excell and the online microsoft tutorial... suggest checking out that link and thumbing through the book at a store before buying it.
Rating:
Summary: Not helpful for an intermediate programmer
Review: When purchasing this book, I already had in mind the macros that I wanted to program and the logic I was going to use in order to accomplish the task. All I was really looking for was a breakdown of the syntax in VBA (I'm new to the language), and a list of commands that were available. Trying to extract this information from the book was tedious at best. It would have also been useful if there was an example or two of how some of the basic syntax works. I can only really use it as a second reference from the help menus already provided in excell and the online microsoft tutorial... suggest checking out that link and thumbing through the book at a store before buying it.
| 
