A Non-Programmers Guide to Using Macros
Macros are simply a collection of Visual Basic for Applications (VBA, a simplified version of Visual Basic) code that allows the application (in this case Inventor) to perform complex actions automatically with limited user input. An example of a macro might be a program that inserts multiple parts into an assembly document or even simply a toolbar button that accesses a menu command that does not have a default toolbar button.
Read more
Using Visual Basic for Applications Code
The native programming language for Microsoft Office
More powerful and flexible alternative to macros
Ch 10: attached a macro to a command button user clicks button
Click event occurs
macro runs
Read more
INTRODUCTION TO VISUAL BASIC FOR APPLICATIONS (VBA)
This tutorial introduces you to Visual Basic for Applications (VBA), a version of Visual Basics which comes with Microsoft Excel. You will learn how to type in and run a simple program in the form of a Function block.
Read more
Teaching Spreadsheet-Based Decision Support Systems with Visual Basic for Applications
Office 2000 has become a standard desktop application package for employees of virtually all Fortune 500 organizations and most small and home offices. The spreadsheet component of Office 2000, Excel, is widely used throughout the business world today for processing quantitative data and developing analytical solutions. The ability to build decision support systems (DSS) based on these spreadsheet solutions can facilitate knowledge management and increase information utilization within an organization. This paper describes our experiences in preparing for and teaching a new course offering for undergraduate information systems majors in developing DSS with Visual Basic for Applications, the programming language for Excel. As a result, we hope to encourage other educators to explore this new technology as a worthwhile addition to information systems curricula.
Read more
Access Tutorial 12: An Introduction to Visual Basic
Programming can be an enormously complex and difficult activity. Or it can be quite straightforward. In either case, the basic programming concepts remain the same. This tutorial is an introduction to a handful of programming constructs that apply to any “third generation” language, not only Visual Basic for Applications (VBA).
Read more