Editorial Reviews. About the Author. Steven Roman, Ph.D, is a professor emeritus of Why is ISBN important? . Newly updated for Excel , Writing Excel Macros with VBA, 2nd Edition provides Excel power-users, as well as programmers. Writing Excel Macros with VBA, 2nd Edition. 1 review. by Steven Roman PhD. Publisher: O'Reilly Media, Inc. Release Date: June ISBN: Newly updated for Excel , Writing Excel Macros with VBA, 2nd Edition provides Excel power-users, as well as programmers who are unfamiliar with the .
|Language:||English, Spanish, Indonesian|
|ePub File Size:||16.43 MB|
|PDF File Size:||9.65 MB|
|Distribution:||Free* [*Regsitration Required]|
Writing Excel Macros with VBA, 2nd Edition. By Steven Roman, Ph.D. Publisher: O'Reilly. Pub Date: June ISBN: Writing Excel Macros with VBA, 2nd Edition Steven Roman ebook. ISBN: , Page: Publisher: O'Reilly Media Format: pdf. Personal collection of soundofheaven.info,.net, vba and other books regarding vb VBA-and- Excel-Books-and-PDFs/Writing Excel Macros with VBA 2nd Ed pdf.
IsCalculated Property Write a customer review. Address Property Read-Only String Variable Scope 5. Color property Published in: Setting Up the Custom Menus
Like this presentation? Why not share! An annual anal Embed Size px. Start on. Show related SlideShares at end. WordPress Shortcode. Published in: Full Name Comment goes here. Are you sure you want to Yes No. Be the first to like this. No Downloads.
Views Total views. Actions Shares. Embeds 0 No embeds. Walkenbach, who understands that people are either new to programming or under a time cruch, and that sometimes a few explicit examples or extra explanation is appropriate.
I own both authors and use both regularly. All in all, a solid reference for the right audience. Some of these are quite good and have many useful examples. However, once one understands the basic techniques, accomplishing one's goal primarily requires detailed knowledge of the Excel object model.
This book's coverage of the Excel object model is by the far the best I have seen and is well organized and through. It explains the intent of the properties and methods rather than just explaining the syntax.
The author also details various caveats about how various components within the object model operate. This is very useful. As a simple example, he explains that setting the Chart objects.
HasAxis property before the Chart has any data series defined will result in a cryptic error that is not covered in the documentation.
Without this information one might end up blindly copying some ugly code from the macro recorder that seems to work though it wouldn't be clear just why this code worked while the other method failed.
Eventually however, this will probably become the "goto" reference. 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. Very good, lil on rambly side but explained well.
Seems outdated, but works perfectly in my excel This book is kind of old and I believe there should be a lot better tutorials in this area. However, it is cheap and affordable. The paper quality and layout are poor and papers may get detach from the book cover easily.
Just realize this is a pretty outdated version of the book before you pull the trigger.
One person found this helpful. Just realized that this is "newly updated for Excel " See all 34 reviews. Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more about Amazon Giveaway. This item: Set up a giveaway. What other items do customers buy after viewing this item? Members that Produce Actions ConvertFormula method Evaluate method Goto method Quit method Miscellaneous Members InputBox method Selection property Intersect method Union method Children of the Application Object Name Objects and the Names Collections The Windows Collection and Window Objects The WorksheetFunction Object The Workbook Object The Workbooks Collection Add Method Close Method Count Property Item Property Open Method OpenText Method Activate Method DisplayDrawingObjects Property Name, FullName, and Path Properties PrintOut Method PrintPreview Method Protect Method RefreshAll Method Save Method SaveAs Method SaveCopyAs Method Children of the Workbook Object The CustomView Object The Names Collection The Sheets Collection The Styles Collection and the Style Object Sorting Sheets in a Workbook The Worksheet Object Properties and Methods of the Worksheet Object Children of the Worksheet Object Protection in Excel XP The Protection Object The AllowEditRange Object The UserAccess Objects Printing Sheets Print button The Declarations section Print button code The PrintSheets procedure The Range Object The Range Object as a Collection Defining a Range Object Range Property Cells Property Column, Columns, Row, and Rows Properties Offset Property Additional Members of the Range Object AddComment Method Address Property Read-Only String AutoFill Method AutoFilter Method AutoFit Method AutoFormat Method BorderAround Method Calculate Method Clear Methods ColumnDifferences and RowDifferences Methods ColumnWidth and RowHeight Properties Width, Height, Top, and Left Properties Consolidate Method Copy and Cut Methods CopyFromRecordset Method CreateNames Method CurrentRegion Property Delete Method Dependents and DirectDependents Properties Precedents and DirectPrecedents Properties End Property EntireColumn and EntireRow Properties Fill Methods Find Method FindNext and FindPrevious Methods Formula and FormulaR1C1 Properties FormulaArray Property HasFormula Property Read-Only HorizontalAlignment Property Insert Method Locked Property Merge-Related Methods and Properties Next and Previous Properties NumberFormat Property Parse Method PasteSpecial Method Replace Method Select Method ShrinkToFit Property Sort Method SpecialCells Method TextToColumns Method Value Property WrapText Property Children of the Range Object The Areas Collection The Borders Collection The Border Object Color property ColorIndex property LineStyle property Weight property The Characters Object The Comment Object The Font Object The FormatConditions Collection The Interior Object Color and ColorIndex properties Pattern property PatternColor and PatternColorIndex properties The QueryTable Object The Validation Object Getting the Used Range Selecting Special Cells Designing the Utility Designing the Dialog The Frame control Control names Tab Order Some final tips Writing the Code Pivot Tables The PivotTable Wizard The PivotTableWizard Method The PivotTable Object Naming Data Fields The Complete Code Properties and Methods of the PivotTable Object Returning a Fields Collection ColumnFields property DataFields property HiddenFields property PageFields property PivotFields property RowFields property VisibleFields property Totals-Related Members Returning a Portion of a PivotTable ColumnRange property DataBodyRange property DataLabelRange property PageRange and PageRangeCells properties RowRange property TableRange1 property TableRange2 property PivotSelect and PivotSelection Additional Members of the PivotTable Object AddFields method CalculatedFields method Errors-related properties Null-related properties EnableDrillDown property Formatting properties and methods Refreshing a pivot table PageField-related properties Name property ShowPages method SourceData property Children of the PivotTable Object The PivotField Object AutoShow-Related Members Sorting Pivot Fields The Fundamental Properties Function property NumberFormat property Orientation property Position property