Learning Excel VBA for Beginners: Understand the Basic and Build a Sample Project - 4639

VB (Visual Basic) and VBA (Visual Basic for Applications) are using same programming language “Basic” and use “VISUAL” layer which allows developers to create user friendly user forms and controllers and act as a Integrated Development Environment (IDE) to help in Application development. However, VBA works within a ‘host’ application like Word or Excel or AutoCAD and it cannot work independently like a standalone application. But .NET VB can create DLL and EXE files and run as a Standalone application. This means that the programs can run independently like any other applications. So please remember that VBA can’t work as a standalone application, so we have to build any application using Excel or MS-Access. In this book we will learn Excel based application using VBA. VBA allows you to automate various activities in Excel such as generating reports, preparing charts & graphs, doing calculations, do repetitive task, etc. This book covers some basic information about VBA including the different data types and variables that you can use to automate processes and functions. People use Excel VBA for multiple reasons like Creating budget, Data base, generating invoices, analysing data, submit a Report, Developing Graphical charts using data and Forecasting. There are many applications available in the market developed by different vendors, but it will not exactly match to your requirement. To use such application, you have to sacrifice some needs, or you have to go around with different loop and achieve a task. So, you can either tweak those applications or develop new applications using VBA. You can use these new applications to complete your work in a few minutes or less. In this book you can learn the VBA from basic to advanced level in step by step with examples. To build a small application, we have to follow some discipline and procedures. To understand the application building, I am going to explain a small application, Home Budget which is commonly used by every one thos who are castipus to expentiture.
ASIN: B0CRHS7DYH
VSKU: BVV.B0CRHS7DYH.A
Condition: Acceptable
Author/Artist:V, Santhana Krishnan
Binding: Paperback