Listing Folder Contents in Excel 2010

Hi there,

I've encountered the Filesearch change in Excel 2010 and I'm struggling to amend my code. The code I have is designed to examine the contents of a folder, create a new worksheet, and then list file names. It works fine in Excel 2003 but, despite trawling the forums, I haven't been able to come up with a solution. Here's my existing code.

Please Login or Register  to view this content.

If anyone has similar code that works in 2010 I'd be eternally grateful for any help

Many thanks

Mike

I've managed to sort this now.... the following code works in Excel 2010

Please Login or Register  to view this content.