- #Visual basic for applications training how to
- #Visual basic for applications training update
- #Visual basic for applications training code
- #Visual basic for applications training series
#Visual basic for applications training series
So you want to compile everything that they've accomplished, summarize it somehow and then create a series of tables or graphs that makes it easy for the high level executives to visualize the work that people have done. For instance say the Macro you created is taking one month's worth of tasks that are performed by the people in your company.
#Visual basic for applications training update
But VBA even allows you to take those Macros and update them.
#Visual basic for applications training code
It uses a VBA Module much like the VBA code that you would write. And you can record that, save that Macro and then just run that Macro all the time. Many of the Microsoft Office products allow you to record a Macro which is the same steps, the same series of things you're doing by clicking on different parts of the screen or typing in certain items. Now some of you may recognize that what I'm describing is a Macro. Where you're doing the same steps all the time. It also allows you to save repetitive things that you do on a regular basis or repeatedly. You're telling the computer exactly what to do. It doesn't need an icon, it doesn't need a pre-saved set of instructions. The advantage with VBA is you can write a module that does that and you are just telling the computer specifically what to do. So you'd have to figure out a way to do it inside the different items that Microsoft has provided you. But say you want to do something a little bit different? Well it's not there. But it's all within what they figured would be the steps or the procedures that people would want. And they will provide the means for some more experienced users to be able to do things. See when Microsoft creates these they look at well what would be the needs of the general or average user? And they'll create some procedures that can be activated by the click of an Icon Button up on the top of the screen. So why would you want to use it? Well as I said what VBA allows you to do is to customize your Microsoft Office product to do things that didn't automatically come with the product. So you don't have a lot of the shortcuts that you might have in other development environments. Well not exactly English sentences, you're writing statements in the language that will then be translated by the computer into computer speak, so the computer knows what it is that needs to be done. You got a blank window and you're typing sentences. Then you would customize and kind of tweak to look the way you want. Most of the applications have some nice little icons where you can click and have some base structures created on the web page. You know that in most programs that allow you to program in HTML and they're multiple applications out there that allow you to do that. HTML by the way is a language that is most frequently used in the world to create web pages. For instance if anybody has heard of HTML or done any programming in HTML. However VBA has a disadvantage versus some other programming languages in that the window, the environment in which you are writing VBA is very simple. You do not need to know the inner workings of the computer or how the computer will use the information you're providing it in order to be able to code in VBA.
But VBA gives you a lot of latitude and it's really very simple. Certain reserved words in the language that the computer needs to recognize and that's similar to other programming languages. It does provide a series of structures which is the way things are organized and Keywords. VBA is a very, very simple programming language. Well you might have to know that for some programming languages but not for VBA.
#Visual basic for applications training how to
They hear programming language and they think oh my god, I need to know a lot about how the computer works and how to talk to it and all the internal mechanisms of the computer. Now the minute I'd used that term, some people may cringe. Now VBA is a very simple programming language. And that's really where the power of VBA comes in. Because those are the two products where people who have been using the product long enough and getting very advanced and experience have a tendency to want to create much more complicated items. Most Microsoft Office products have VBA Modules running though they are most commonly used with Excel and with Access. All the user would see is the result of that module running, whatever it causes to happen in the product. They don't see the Module Window itself come up. They do not get a little message that pops up on the screen that says you are now running a VBA Module. Now the average user does not know these are happening. It is a tool to create executable modules that would run in the background behind the various Microsoft Office products like Word, Excel, PowerPoint, Access, Outlook, et cetera.
VBA stands for Visual Basic for Applications.
In this lesson I will discuss what is VBA.
0 kommentar(er)
