| You Can Automate Your Microsoft Office in | | | | is savedin a spreadsheet, and then show the |
| About 60 Minutes | | | | addresses in the Worddocument. Also, we can |
| | | | write an application to use Word toautomate |
| Copyright © 2005 Tenny Ing | | | | Outlook for reading the contact and any other |
| | | | data inthe Contact or other folders. Or, we |
| Viccomp, Inc. | | | | can use Outlook to read in |
| | | | |
| Microsoft Office program is a programming | | | | Word or Excel scheduling list and use it to |
| tool called Visual | | | | schedule tasks in |
| | | | |
| Basic for Applications (VBA) that comes with | | | | Outlook. |
| Microsoft Excel, | | | | |
| | | | Writing VBA programs is quite straightforward |
| Word, Outlook, Power Point, and Publisher. | | | | and can be learnedin a short period, |
| VBA can make yourrepeating jobs automatic. | | | | providing that there are tutorials that |
| It also can customize Excel, Word andother | | | | arewell organized and illustrated with many |
| Office procedures for your own needs. >From | | | | pictures. After goingthrough a few |
| Office version | | | | tutorials, the learner can explore on himself |
| | | | orherself the other possibilities with the |
| 2000, all the Office programs are equipped | | | | programming. Learningprogramming is not as |
| with VBA. | | | | hard as people think. Rather it can be afun |
| | | | experience to see the programs work. |
| Hand-On experience is the key to be a good | | | | |
| programmer. | | | | Besides we need to be good at writing |
| | | | programs, keeping our |
| Programming tutorials are the easier way to | | | | |
| learn any computerprograms including VBA. | | | | Windows and Office up-to-date is as |
| For example, a tutorial can show peoplehow to | | | | important. Please rememberto visit Microsoft |
| use VBA to automate (make automatic) an Excel | | | | website to do automatic Windows and Office |
| routine likeupdating the fonts and sizes for | | | | |
| a range of cells, orautomatically pops up a | | | | Update at least once a month, which will |
| calendar for selecting a date. VBA canalso | | | | assure you have thenewest fixes and updates. |
| be used as a tool to automate Word mail-merge | | | | |
| or create atext file from a Word document. | | | | There are a few free VBA learning tutorials |
| VBA can even be used as a toolto automate | | | | at If you would like to learn beyond the |
| email alert in the Outlook Inbox or | | | | freetutorials, you can sponsor us with the |
| scheduling taskto do. | | | | other low cost tutorials. |
| | | | |
| VBA can make one application like Excel work | | | | You can also request a tutorial for your own |
| with anotherapplication like Word and | | | | needs with therequest entry of the Contact |
| Outlook, or any other combination. Tomake | | | | page. |
| Excel work or control Word is called Excel | | | | |
| automates Word. | | | | See how Viccomp's tutorials can show you how |
| | | | to write your first |
| Likewise, Word works with or controls Outlook | | | | |
| is called Wordautomates Outlook. | | | | Office program ==> |
| | | | |
| There can be many applications of automation | | | | Just download the free tutorials to try, or |
| that was introducedin the previous paragraph. | | | | more tutorials fora small fee. Please use |
| For example, we can write a VBAapplication | | | | the Contact page for your request ofa |
| to make Word read an Excel address list that | | | | tutorial or programming. |