This Excel user's guide to VSTO—the new Excel Macro programming language being promoted by Microsoft—shows how to perform the equivalent VBA actions with VSTO. The differences between the VSTO and VBA development environments are explained, helping Excel users decide if they should embrace VSTO or seek out other technologies.
Book Description
Editorial Reviews
About the Author
Dr. Gerard M. Verschuuren is a Microsoft Certified Professional specializing in VB, VBA, and VB.NET. He is the author of Excel for Scientists and Slide Your Way Through Excel VBA. He lives in Atkinson, New Hampshire.
Product Details
Would you like to update product info or give feedback on images?
|
More About the Author
I am a human geneticist who studied and worked at universities in Europe and the USA. Currently, I specialize in using computer programs such as Excel, XLfit, VBA, VB.NET and C#.NET for scientific and other purposes - and I spend much time providing training on these programs. I am also a Microsoft Certified Professional. Besides, I am the author of many books, CDs, and DVDs.
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
2 of 2 people found the following review helpful:
3.0 out of 5 stars
Guided Tour,
Amazon Verified Purchase(What's this?)
This review is from: From VBA to VSTO: Is Excel's New Engine Right for You? (Paperback)
I haven't quite finished reading the book, but I am close to the end. The book is really a guided tour for migrating to using VSTO in Visual Studio to program for Excel in VB.Net, as a successor to VBA. The book is not intended to teach VB.Net or Visual Studio, but just to hilight the migration path for Excel VBA programmers to move to VSTO in Visual Studio using VB.Net. The book assumes a knowledge of Excel VBA, as well as VB.Net, that is beyond my background, which is limited to mathematical programming for mechanical engineering, so a fair portion of what the author presented was not entirely intelligible to me (particularly the database programming). I understood what he was trying to do in his coding examples, but the syntax was not dissected in a manner that a true teaching textbook would have done. However, I knew this going in, and it served my purpose, by quickly targeting the topics I will need to learn in order to upgrade my Excel VBA programming skills to VSTO. I am in the process of beginning to learn VB.Net from other books, and I now know what to focus on. Hopefully, the authors of beginning-intermediate Excel VBA programming books will soon update their books to VSTO for VB.Net, which will provide a more accessible upgrade path for Excel VBA mechanical engineering programmers. I think that Microsoft is the holdup here, because they haven't committed to providing VSTA (Visual Studio Tools for Applications) built in to Microsoft Office, like they provide VBA built-in, and until they do, VSTO and VB.Net will not become the mass-market alternative to Excel VBA, that will attract authors to revise their Excel VBA training books to VSTO for VB.Net.
2 of 3 people found the following review helpful:
5.0 out of 5 stars
Great Transistion Book,
By
Amazon Verified Purchase(What's this?)
This review is from: From VBA to VSTO: Is Excel's New Engine Right for You? (Paperback)
The book does a great job at helping an accountant make the transition between VBA and VSTO, which is not an easy thing. It is written a good level, you don't have to be a PROGRAMMER to understand it.
If your company is thinking about making the transition to the newer version of Microsoft Office, this will eliminate VBA, so you need this book.
0 of 1 people found the following review helpful:
5.0 out of 5 stars
Got it fast,
Amazon Verified Purchase(What's this?)
This review is from: From VBA to VSTO: Is Excel's New Engine Right for You? (Paperback)
If you are considering the move from VBA to VSTO, then you will want to have this book.
Amazon's shipper got it to me without delay.
Share your thoughts with other customers: Create your own review
|
|
Inside This Book
(learn more)
First Sentence:
VSTO stands for Visual Studio Tools for Office and is sometimes pronounced as "Visto." Read the first page Key Phrases - Capitalized Phrases (CAPs): (learn more)
End Sub, Private Sub, Public Class, Code Example, End Try, Imports System, Solution Explorer, Exit Sub, Microsoft Office, New Integer, Visual Studio, Visual Basic, Select Case, End Select, Startup Dim, Try Dim, Immediate Window, Module Sub, New System, Public Sub, Rosetta Stone Figure, New Font, Server Explorer, Windows Form, Add Item New!
Books on Related Topics | Concordance | Text Stats Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
VSTO stands for Visual Studio Tools for Office and is sometimes pronounced as "Visto." Read the first page Key Phrases - Capitalized Phrases (CAPs): (learn more)
End Sub, Private Sub, Public Class, Code Example, End Try, Imports System, Solution Explorer, Exit Sub, Microsoft Office, New Integer, Visual Studio, Visual Basic, Select Case, End Select, Startup Dim, Try Dim, Immediate Window, Module Sub, New System, Public Sub, Rosetta Stone Figure, New Font, Server Explorer, Windows Form, Add Item New!
Books on Related Topics | Concordance | Text Stats Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
Citations (learn more)
This book cites 6
books:
See all 6 books this book cites
- Case Study by Ken Stone on 24 pages
- Excel for Scientists and Engineers (Excel for Professionals series) by Dr. Gerard Verschuuren in Front Matter, and page 217
- Pivot Table Data Crunching by Bill Jelen on page 212, and Back Matter
- Excel for Marketing Managers (Excel for Professionals series) by Ivana Taylor on page 212, and Back Matter
- Excel for Teachers (Excel for Professionals series) by Colleen Conmy on page 212, and Back Matter
See all 6 books this book cites
Books on Related Topics
(learn more)
|
|
What Other Items Do Customers Buy After Viewing This Item?
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Customer Discussions
|
This product's forum
Active discussions in related forums
Search Customer Discussions
|
Related forums
|
