With Application.Filesearch error in Excel 2010 VBA

[santhisrinivas]

Hi Guys,

While running below code I am getting "Object doesnot support this action" error is comming in this line "With Application.filesearch". could you please help me for solving this issue.

I am posting my code, can anyone help me.

Please Login or Register  to view this content.

Thanks in advance.

[RHCPgergo]

Hi,

excel 2007 and later versions don't seem to support the Application.FileSearch method. This link describes another way: http://www.ozgrid.com/VBA/2007-files...lternative.htm

[OllieB]

Or a soution I psted in the tips section of this forum

http://www.excelforum.com/tips-and-t...ch-object.html