Renaming Files using VBA through Excel
You have now discovered why you should *always* tell us what version of
Excel you are using when you ask a question on these newsgroups...
FileSearch was removed from Excel 2007. Here is a forum link that has some
alternatives shown as links within the discussions... take your pick for a
replacement.
--
Rick (MVP - Excel)
"J_Knowles" wrote in message
...
Mike Spencer,
Thanks for the code. I'm getting this error:
"object does not support this action"
Set fs = Application.FileSearch
The FileSearch is hidden in 2007. Is there a work around?
--
Data Hog
"Mike Spencer" wrote:
Hi Michelle;
I went looking for this not to long ago to rename a couple thousand files
at a time to re-organize archive files.
|