devxlogo

Sometimes you Don’t Need a Variable

Sometimes you Don’t Need a Variable

If you’re going to use an object and get rid of it after a few lines, you don’t need to declare a variable to it. Just use With. Here is an example:

With CreateObject("Scripting.FileSystemObject")    FullPath = .BuildPath(Path, FileName)    If Not .FileExists(FullPath) Then        Rem Do something...    End IfEnd With

devx-admin

Share the Post: