Good afternoon,

Can someone please tell me how I could go about using variables declared within an If/Then statement outside of the block but in the same procedure. Example:

Public Sub Test()
If test = 1 Then
    Dim var As OleDBConnection
Else
    Dim var As sqlConnection
End If
End Sub

Thank you in advance.


Dolphin Bay, Inc. -- turning visions into eReality(tm) -- West Palm Beach, FL
Website Design, Internet Strategy, Search Engine Marketing

www.DolphinBay.biz

If you dim them within the if statement then they are only valid within the if statement. That means you can't really do conditional dim's


Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

...and in my opinion, this is somewhat bad form. I always stick to the rule of declaring my variables at the beginning of functions. This keeps them grouped and is MUCH easier to read later on when you are trying to find where the var is declared. If you only declare the object (but not instantiate it) you shouldn't suffer from too much of a performance hit.