File picker in excel 2007

[irfanparbatani]

Currently I am using this code in excel 2003, but it gives me an error in excel 2007 when using the below code: the object cannot be supported.

Please Login or Register  to view this content.

Can someone help me to execute the above code to execute in excel 2007?

Any response would be appreciated.

[irfanparbatani]

Any help would be appreciated.

[jayinthe813]

http://www.vbaexpress.com/forum/showthread.php?t=16326

FileSearch has been dropped as of Excel 2007, apparently.

[jaslake]

Here's another link
C:\VBA Code\Application File Search\...Filesearch.mht

[irfanparbatani]

Hello John,

The link is not working, can you please post a working link.

Thanks

[jaslake]

Yah...well it won't...my screwup...try this
http://excel2007tips.blogspot.com/20...h-in-2007.html
Sorry about that.

[irfanparbatani]

Thanks john for the link, but how will it fit in my code above?

[jaslake]

Hi irfanparbatani

I've used this code successfully many times so, I know it works. I'm not intuitive enough to apply in your environment but there are many on the Forum that are.
If you post your workbook perhaps I can help...perhaps not.

If you don't get further responses in a reasonable time simply respond to your Thread with "Bump".

[irfanparbatani]

I can send you the workbook. below is the workbook attached.

[jaslake]

Hi irfanparbatani

Have your workbook...have your code. I believe we can work with this but not tonight. Have Grandpa duty in the AM and it's a bit late. I'll look at this tomorrow. If you've not a solution by then I'm fairly confident we can find one for you.

Get back to you.

[irfanparbatani]

Thanks for the reply. cheerz no hurry mate. take your time. I will work on the report as well.ttyt. good night.

[jaslake]

Hi irfanparbatani
Try the code in the attached...it appears to do as you require. Let me know of issues.

[irfanparbatani]

Thanks for the reply, I will test it soon and give you a buzz, how abt that?

[irfanparbatani]

Thanks for the reply, I will test it soon and give you a buzz, how abt that?

The file is not working as when I hit run, it just doesnt run, can you please test it.