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

VBA TUTOR NEWSLETTER #Beta ~ 20-12-1999 Help for the beginner to intermediate VBA programmer

Welcome to the beta issue of VBA Help, which will be issued on the first and fourteenth day of each month! We hope it provides both the beginner and intermediate VBA user with tips, examples and links that will be useful for their VBA projects. For this beta edition, we will be concentrating on the BASICS, with some essential tips and links to demonstrate how to setup Office '97 for VBA use. If this newsletter does not display properly on your system, please let us know, along with a brief description of the problem.

~ VBA in GENERAL ~

At the top of your modules, you should always put the statement 'Option Explicit'. You can make it the default so you don't have to type it by selecting the option in the Tools|Options dialog in the VB Editor. Why? Because you SHOULD declare all your variables before using them. This adds a little bit to development time, but saves an awful lot of debugging time when things go wrong.

~ VBA in WORD ~

It is ESSENTIAL to password protect your VBA projects to protect them from Macro Virus attacks. Unfortunately, even with regular virus protection updates, you can still be 'GOT'. So .... Go to the Microsoft 'Office Developer' site for a clear explanation of how to do it.

~ COOL WORD RESOURCE ~ Microsoft Office Developer Web Forum ~ For WORD

~ VBA in EXCEL ~

Although it is not just for EXCEL, an essential EXCEL resource is the Microsoft Personal Online 'Support Highlights for your Product'. Start to browse here .

~ COOL EXCEL RESOURCE ~ Microsoft Office Developer Web Forum ~ for EXCEL

~ VBA in ACCESS ~

Using VBA in ACCESS is not one of our strengths, so in this section we will just point you towards some excellent resources.

~ COOL ACCESS RESOURCE ~ Microsoft Office Developer Web Forum ~ for ACCESS [ SKILL LEVEL: Intermediate to Advanced ]

VBA TIP REQUEST FORM Contact Name: Tip Request: To unsubscribe to this newsletter, reply with 'unsubscribe' as the subject. You can resubscribe at a later date from the VBA Tutor home page.

© 2000 Gary Radley