Hi all,
Using Excel 2007
I use the GetFolder() method of the FileSystemObject to consolidate some files
Set objFolder = FSO.GetFolder(strDirectory)
I destroy the Folder and File objects when the first For Each..Next loop completes
Set objFile = Nothing
Set objFolder = Nothing
Now I want to use the GetFolder() method again with a different directory
Set objFolder = FSO.GetFolder(strMapTemplates)
However, on the second loop the files from the 1st folder are accessed?
I have reviewed the variables
strDirectory = "c:\dir1\"
strMapTemplates = "c:\dir2\"
Any other idea(s) what to check on?
thx
w
Bookmarks