DataTypes
Using the Data Types Symbols
You may have seen some methods written as Left$(...) and not Left(...)
$ version returns a String, and the non $ version returns a variant
Here is a list:
End with:
| $ | String |
| % | Integer (Int32) |
| & | Long (Int64) |
| ! | Single |
| # | Double |
| @ | Decimal |
Start with:
| &H | Hex |
| &O | Octal |
 VBA
Private Sub Form_Load()
variable1=Dir$(some_path)
variable1=Dir(some_path)
variable1=string(Dir(some_path))
End Sub
By: Alex Hedley
Click here to sign up for more FREE tips
| 
