GetFolder Method of FileSystemObject Fails On Second Pass

Hi all,

Using Excel 2007

I use the GetFolder() method of the FileSystemObject to consolidate some files

Please Login or Register  to view this content.

I destroy the Folder and File objects when the first For Each..Next loop completes

Please Login or Register  to view this content.

Now I want to use the GetFolder() method again with a different directory

Please Login or Register  to view this content.

However, on the second loop the files from the 1st folder are accessed?
I have reviewed the variables

Please Login or Register  to view this content.

Any other idea(s) what to check on?

thx
w

Thanks biocidej,

I tried adding a second folder objFolder2
Now when I run I get an error on the first GetFolder

Error message states "FileName.xls could not be found"
If that is true, how does it pickup the filename in th first place?
The filename it says it cannot find is correct.
I opened the folder and I can see the file

I set a break point immediately after

Please Login or Register  to view this content.

I hover on the variable strDirectory (returns "C:\dir1\" as expected)
I hover on the variable objFolder (returns "C:\dir1") not sure why the "\" is dropped?

I moved the breakpoint down a bit

Please Login or Register  to view this content.

When I hover on objFile here it only shows the name of the file "MapFile.xls"

thx
w

See if you can work with this

Please Login or Register  to view this content.

Thanks Mike,

I ran your code which tought me to use objFile.Path instead of objFile.Name
Works great!

thx
w