Many of the people out there heard about VBA but never actually uses @ this Visual Basic for Application. for most people would believe that this is a visual basic programming but it is not the whole package. But do not underestimate the power of VBA. Most common place to use this is with Microsoft Office application such as Excel to use of auto data retrieval, Calculation, Manipulation, Graph Generation, & link to Power point, Outlook, Visio and other Microsoft Application such as the windows media player etc.
Sounds interesting? it is as interesting programming which can be learned with a short period of time, & most basic tools can be learned from just using a recording function. Yes.. You record a sequence of things you do, & change it into a programming step. Video step below show you on how to record a macro & check out what is the codes needed to execute in VBA form.
Do you want to try your own VBA? one of the fun thing that you can create is an auto-mail macro that is attached with outlook. which can help you to automatically send a birthday wish to your love one so that you won't be sleeping on your couch later of the day (which i forgot to wish my fiance on 12th August 2010) which is actually because i was too occupied with the Debugging work in intel.
So here is your first tutorial on Outlook:-
Create a VBA which sends a birthday greeting (whatever you want) automatically on 12th August (its my date of choice) at exactly 00:00 (but your PC need to be on.
the tips is to use VBA Scripts together with Scheduler.
- i'll post a sample answer here later if there is a demand on the item. :)
No comments:
Post a Comment