>GRSoftware >VBA Tutor >Newsletter Issues >Newsletter #15 >Newsletter #1&

VBA TUTOR NEWSLETTER #16 ~ 1-12-2000
Help for the beginner to intermediate VBA programmer
Subscribers 870 ~ ^120 in November

What a month once again!
Continued Computer problems! SO, I eventually gave up and bought a new PIII 800. I feel a bit like a traitor after running a range of CRYRIX and AMD chips for the last eight years, but my new sytem was the best 'bang per buck' value. Hopefully I will be able to keep up with your requests for help from now on. Sorry about this months Newsletter being a bit 'light on' with tips and links. I will try and make up for it in the CHRISTMAS ~ NEW YEAR BUMPER HOLIDAY EDITION.

~ VBA in GENERAL ~

The tutorial for this month is based on a request for a 'Date/Time' stamp macro to save a EXCEL workbook with the current date and time as its file name. I have extended this to show how it can be used in a document, workbook or template.
[SKILL LEVEL: Beginner to Intermediate ]

~ COOL VBA RESOURCES ~
Search for VB Tools and Products @ www.vbxtras.com, 'The Ultimate Tools Catalog for Visual Basic'.
[ SKILL LEVEL: All ]

~ VBA in WORD ~

You can use VBA to load WORD files and run macros from any Microsoft Office application that supports automation. A simple tutorial can be found @ MS Office Developer Web Forum.

~ COOL WORD RESOURCES ~
Use bar codes? Have a look at the free WORD bar code macros available for download at www.idautomation.com.
[ SKILL LEVEL: Intermediate]

~ VBA in EXCEL ~

Although not as important as it used to be, optimized code should be considered in large VBA projects. Have a look at some ways to optimize you VBA code @ Pearson Software Consulting.

~ COOL EXCEL RESOURCES ~
One place to find some good EXCEL tips is at www.deja.com where there are several special interest EXCEL forums such as public.excel.charting.
[ SKILL LEVEL: Beginner to Intermediate ]

~ VBA in ACCESS ~

You can easily set up a text box in ACCESS to mask entries with asterisks by displaying the properties for the text box in Design view and changing the 'Input Mask' property to 'Password'.

~ COOL ACCESS RESOURCES ~
60 ACCESS tips can be found @ www.access-programmers.co.uk.
[ SKILL LEVEL: Intermediate to Advanced ]

© 2000 Gary Radley