I have a script that opens a file location but it turns out that the script needs to open mulitple file locations.
Hows the best way to do this with the exisitng code i have alread yset up?
Hes how my code to open 1 file location:
sFolder = "C:\MyMachine\XML_Parser_\Txt"
'Check for txt files
For Each oFile In oFSO.GetFolder(sFolder).Files
If UCase(oFSO.GetExtensionName(oFile.Name)) = "TXT" Then
ProcessFiles oFSO, oFile
Set oFSO = Nothing
Sub ProcessFiles(FSO, File)
'Do my stuff here
Can i use my variable sFolder to specify more than one folder location?