View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default 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.