Solved

File System Object And Two Different Directories

Posted on 2006-10-25
2
180 Views
Last Modified: 2010-04-30
I am trying to write a program that will go through two different directories.  It will go through the first directory and do some file processing.  After it does the processing for the first folder, I need to go through a second set of folders.  Is it better or is in the best practice to create two different file system object?  Currently I am using two but wanted to make sure I am following the best coding practice.

      Set objFSO = CreateObject("Scripting.FileSystemObject")
      Set objFolder = objFSO.GetFolder(strErrorDir)
      Set colFiles = objFolder.Files

      Set objFSOS = CreateObject("Scripting.FileSystemObject")
      Set objFolderS = objFSOS.GetFolder(strSuccDir)
      Set colFilesS = objFolderS.Files

Thanks
0
Comment
Question by:RVattakunntel
2 Comments
 
LVL 17

Assisted Solution

by:CSecurity
CSecurity earned 250 total points
ID: 17808353
Creating multiple instances do not makes problem...

You can also first unload a variable then reset it...

Like:

 Set objFSO = Nothing

 Set objFSO =  CreateObject("Scripting.FileSystemObject")

;)
0
 
LVL 18

Accepted Solution

by:
Sethi earned 250 total points
ID: 17808605
Creating multiple variables has its disadvantages:
1. It takes more memory space.
2. It takes time to instantiate a new FSO variable.
3. More code needs to be written to define and set variables to nothing.

This job can be easily done through one variable.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now