ConsciousVibes.com

Home | Links ( Motorcycles, Computers )

• Print ListView and Tree View Controls' Contents
• Declare All Variables & Option Explicit
• Keep Your Code Portable by Using App.Path
• Visual Basic .NET Tips
• VBA (Visual Basic for Applications) Tips
• Computer Tips Index

Declare All Variables & Option Explicit

Declare all variables to save programming time by reducing the number of bugs caused by typos (for example, aUserNameTmp vs. sUserNameTmp vs. sUserNameTemp).

In Visual Basic 6, go to Tools > Options > Editor tab, then turn on "Require Variable Declaration." This should add "Option Explicit" to the General Declarations section of any new modules or forms you create. You can also manually type in "Option Explicit" , without the quotes, at the top of the code for each form/module that has already been created.

Keep Your Code Portable by Using App.Path

Would you like to avoid having to modify the path in your Visual Basic program, every time you need to run it from a different subdirectory or drive?

Use these steps to make your life easier:

1. Add the following commands to Sub Main() in the main module or to Form_Load() in the main form.
   
      ChDrive App.Path
      ChDir App.Path


2. Wherever you have hard coded the full path to a file, remove the path leaving just the filename.
   
   For example; Change “C:\Data\VisualBasic\VideoStore.mdb” to “VideoStore.mdb”.


3. Make sure that the file being accessed is in the same location as the project that needs to access it.