Hi,
Previous I wrote a VBA code using "Application.FileSearch" to loop through files in pre-selected folder + subfolder(s) for further processing & analysing.
It work fine in XL 2003. But when recently my company start to use XL 2007. That code appear return an error.
When I search through help file, i was told that that "Application.FileSearch" code been "hideen" (?) in XL2007 VBA.
Please advice any method for me to loop through files in pre-selected folder (+subfolders if need) inside VBA code?
Btw, I knew that is more code been hidden in XL2007. Just in case i need to find replacement for those code, any reference/site recommended?
Thanks.
Bookmarks