You Can Automate Your Microsoft Office in About 60 MinutesWritten 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, all Office programs are equipped with VBA.Hand-On experience is key to be a good programmer. Programming tutorials are 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 updating 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 in 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 in 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 show addresses in Word document. Also, we can write an application to use Word to automate Outlook for reading contact and any other data in 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 in 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 in 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 in background light green - although it could have been cyan. The bamboo chair was obviously a bamboo colour. That just left colour of her hair to try and figure out.
|
