Excel 2007 : Excel 2007 Macro issue

[lokesh.satya]

Hi All,

I am unable to use the " With Application.FileSearch " option in Excel 2007.

The Macro was created in Excel 2003. It does not work in Excel 2007.

Please suggest a solution.

The Macro is attached below for your reference.

Regards,

Lokesh

[OnErrorGoto0]

Try searching the board. There must be lots of posts about Filesearch replacements.

[lokesh.satya]

I am Searching for related posts. I am not getting the exact one to rectify my issue.

Please help.

Regards,

Lokesh

[OnErrorGoto0]

You can use Dir to find files, or the Scripting.FileSystemObject.

[lokesh.satya]

Hi Rory,

I am not very sure of editing the attached macro with Dir or the Scripting.FileSystemObject options.

Can you please help me with editing the macro.

Regards,

Lokesh

[OnErrorGoto0]

Try the attached - I obviously cannot test it.