>GRSoftware >VBA Tutor >Newsletter Issues >Newsletter #14 >Newsletter #16

VBA TUTOR NEWSLETTER #15 ~ 1-15-2000
Help for the beginner to intermediate VBA programmer
Subscribers 750 ~ ^85 in October

What a month!
Computer problems [ Motherboard Bios if you are really that interested! ] resulted in the loss of several weeks work, as well as the loss of some subscribers e-mail addresses. I am now backing up the subscriber list EVERY day instead of once a week. I suppose we all like to believe that our trusted computers will not let us down, being non human. However, maybe they are human after all .....

~ VBA in GENERAL ~

The tutorial for this month looks at the automatic installation of an Excel Add-In. This tutorial is a good introduction to the file management capabilites of VBA.
[SKILL LEVEL: Beginner to Intermediate ]

~ COOL VBA RESOURCES ~
Find out what is new for developers in OFFICE 2000 @ 'What's New in the Office' by David Shank, co-author of the Microsoft Office 2000/Visual Basic Programmer's Guide.
[ SKILL LEVEL: All ]

~ VBA in WORD ~

Sick of having your tables in Word breaking across pages? Select the 'Row' tab in 'Table|Table Properties' and deselect the 'Allow Row To Break Across Pages' box. Click on the 'OK' button to finish.

~ COOL WORD RESOURCES ~
[1] Have a look at a great Word Add-In called Wordware 2000 that creates a new toolbar full of some cool Word utilities and enhancements. It demonstrates what can be achieved with Add-Ins.
[2] View the 'Template Gallery' @ officeupdate.microsoft.com/templategallery !
[ SKILL LEVEL: Beginner to Intermediate]

~ VBA in EXCEL ~

When accessing the property sheets of controls, do not confuse the 'Name' and the 'Caption' properties. The 'Name' property is the string you use to identify an object. The 'Caption' property is the string displayed on the object or its lable.

~ COOL EXCEL RESOURCES ~
Have a look at a great Excel Add-In called Edwin's Power Tools that creates a new toolbar full of some cool Excel utilities, demonstrating what can be achieved with Add-Ins.
[ SKILL LEVEL: Beginner to Intermediate ]

~ VBA in ACCESS ~

If you get the message 'Microsoft Access can't be started as there is no license for it on this machine' when trying to start Access '97 after installing Access 2000, then you need to reset the Access 97 license in the Windows Registry. Open access97_licence.txt for full instructions.

~ COOL ACCESS RESOURCES ~
An excellent tutorial on creating 'Robust Access Applications' can be found @ www.officevba.com.
Have a look at Part I, then Part II.
[ SKILL LEVEL: Intermediate to Advanced ]

© 2000 Gary Radley