J
John
What do you use instead of the missing Application.FileSearch?
Thanks
John
Thanks
John
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
Ron de Bruin shares some alternatives here:
http://www.rondebruin.nl/fso.htm
and
http://www.rondebruin.nl/copy3.htm
http://www.rondebruin.nl/fso.htm
and
http://www.rondebruin.nl/copy3.htm
B
broro183
Hi John,
Have a look at RoyUK's example: 'Excel 2007 Filesearch
(http://excel-it.com/Excel 2007/2007_filesearch.htm)
hth
Rob
Have a look at RoyUK's example: 'Excel 2007 Filesearch
(http://excel-it.com/Excel 2007/2007_filesearch.htm)
hth
Rob
J
JLatham
There are several approaches to this in this discussion:
http://social.msdn.microsoft.com/Forums/en/isvvba/thread/a450830d-4fc3-4f4e-aee2-03f7994369d6
I lean toward the use of the file system object (FSO) generally, although
jpschmit puts up a nice solution. Search for jpschmit on the page to find
his post quickly.
http://social.msdn.microsoft.com/Forums/en/isvvba/thread/a450830d-4fc3-4f4e-aee2-03f7994369d6
I lean toward the use of the file system object (FSO) generally, although
jpschmit puts up a nice solution. Search for jpschmit on the page to find
his post quickly.
J
John
thanks. I made do using dir. Had forgotten about that.
JOhn
JOhn