You Can Automate Your Microsoft Office in About 60 Minutes

Written by Tenny Ing

Microsoft Office program is a programming tool called Visual Basic for Applications (VBA) that comes with Microsoft Excel, Word, Outlook, Power Point, and Publisher. VBA can make your repeating jobs automatic. It also can customize Excel, Word and other Office procedures for your own needs. From Office version 2000, allrepparttar Office programs are equipped with VBA.

Hand-On experience isrepparttar 139058 key to be a good programmer. Programming tutorials arerepparttar 139059 easier way to learn any computer programs including VBA. For example, a tutorial can show people how to use VBA to automate (make automatic) an Excel routine like updatingrepparttar 139060 fonts and sizes for a range of cells, or automatically pops up a calendar for selecting a date. VBA can also be used as a tool to automate Word mail-merge or create a text file from a Word document. VBA can even be used as a tool to automate email alert inrepparttar 139061 Outlook Inbox or scheduling task to do.

VBA can make one application like Excel work with another application like Word and Outlook, or any other combination. To make Excel work or control Word is called Excel automates Word. Likewise, Word works with or controls Outlook is called Word automates Outlook.

There can be many applications of automation that was introduced inrepparttar 139062 previous paragraph. For example, we can write a VBA application to make Word read an Excel address list that is saved in a spreadsheet, and then showrepparttar 139063 addresses inrepparttar 139064 Word document. Also, we can write an application to use Word to automate Outlook for readingrepparttar 139065 contact and any other data inrepparttar 139066 Contact or other folders. Or, we can use Outlook to read in Word or Excel scheduling list and use it to schedule tasks in Outlook.

What Colour was Your Great-grandmother's Hair?

Written by Shaun Pearce

I've just made another Photoshop video. This one is about colour tinting (or "colorizing") an old photo. You may not know this, but back inrepparttar 1800's - long before colour photography was invented - people used to hand-tint black and white photographs with coloured inks or water-colour paints, and I wanted to achieve that type of effect. Tinting monochrome prints using Photoshop is considerably less messy!

The photo I decided to use was a recently restored photo of my maternal great-grandmother (my mother's, mother's, mother). It was taken sometime inrepparttar 138805 late 1880's when she probably in her late teens. It's a typical Victorian studio portrait: Great-grandma is wearing her best dress, is standing against a painted background of a garden, and has one hand resting on a rustic looking chair.

The only thing I knew for certain was that Great-grandma had blue eyes, every other colour was a conjecture. Her dress was a dark colour, and after experimenting with a few different colours, I decided that navy blue looked best. I coloured inrepparttar 138806 background light green - although it could have been cyan. The bamboo chair was obviously a bamboo colour. That just leftrepparttar 138807 colour of her hair to try and figure out.

Cont'd on page 2 ==> © 2005
Terms of Use