Writing Excel Macros with VBA: Learning to Program the Excel Object Model Using VBA
Thumbnail 1Thumbnail 2

Writing Excel Macros with VBA: Learning to Program the Excel Object Model Using VBA

4.0/5
产品编号: 8197466
安全交易
经常一起购买

描述

Writing Excel Macros with VBA: Learning to Program the Excel Object Model Using VBA

评论

4.0

全部来自已验证的购买

H**S

Newbies to VBA should avoid this book

I want to learn how to program using VBA. The author seems to constantly imply what a great programmer he is and that you as a new or intermediate user of VBA do not need any examples of VBA code to learn the language.

D**R

Mr Roman's book is very good value.

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.

A**D

Excellent coverage of Excel object model

There are a number books on VBA and on programming Excel with VBA. 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. One can dig through the object browser and/or the Microsoft documentation for this information or use the macro recorder as a 'prototyping' shortcut, but these techniques are somewhat time consuming and are less than complete.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.If one is not already very knowledgeable of Excel and VBA, this book would probably work best accompanied by a book like Walkenbach's, "Excel 2003 Power Programming with VBA". Eventually however, this will probably become the "goto" reference.

J**Z

Solid reference.

The author states that he doesn't mince words or beat around the bush with certain concepts, and he proves to be a man of his word. This is probably more appropriate for macro writers with a little experience. If you're new to programming, you're probably better off in the world of Mr. 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.

N**M

Not the best

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.

A**S

Useful book

Very good, lil on rambly side but explained well.

J**N

Great reference for Finance Excel guy.

Seems outdated, but works perfectly in my excel 2016. Remember that vba its not like C++ or even Python, it doesn't change as much.

E**.

Good overall info

A few annoying typos, but nothing major. Meet my needs and expectations. Showed me how do things I was wondering about with clear explanations.

A**Y

Great Book on VBA

I enjoyed this book for learning more about VBA

A**R

Five Stars

Very good

A**R

This is the book you need if you are new ...

This is the book you need if you are new to VBA.. OR even if you have a fair amount of knowledge in the subject!

常见问题

TrustPilot

TrustScore 4.5 | 7,300多个评论

扎伊纳布 N.

非常棒的服务。送货速度比预期的要快。

1 周前

Anjali K.

产品质量出色。正是我的工作所需要的。

1 个月前

全球购物,通过 Desertcart 享受优惠
物有所值
各种产品的价格具有竞争力
全球购物
为 100 多个国家的数百万购物者提供服务
增强保护
深受全球购物者喜爱的值得信赖的支付方式
客户保证
深受全球购物者喜爱的值得信赖的支付方式。
沙漠车应用程序
随时随地随时随地购物。
MOP$572

关税和税费包括

Macau店铺
1
免运费

with PRO Membership

免费退货

30天对于 PRO 会员用户

15天无会员资格

安全交易

TrustPilot

TrustScore 4.5 | 7,300多个评论

尤素夫·A.

总体来说,体验非常棒。会推荐给朋友和家人。

1 个月前

Neha S.

整个订购过程中沟通顺畅。产品完美。

2 周前

Writing Excel Macros With Vba Learning To Program The Excel | Desertcart Macau