[Help]macro to open file browser, to select a location, and save the location to a cell

**zhuleijia** · 04-03-2013, 06:09 PM

Dear All,

is there a way to use macro to open file browser, ask users to select a location, and save the location to a cell.

Thank you in advance!

**tigeravatar** · 04-03-2013, 06:12 PM

zhuleijia,

I think this is what you're looking for:
http://msdn.microsoft.com/en-us/libr.../ff834966.aspx

**zhuleijia** · 04-03-2013, 06:57 PM

Thank you. it does find the file location.
But is there a similar way to find folders?

**tigeravatar** · 04-04-2013, 11:08 AM

zhuleijia,

Perhaps...

Please Login or Register  to view this content.

**zhuleijia** · 04-06-2013, 09:56 AM

THank you so so much, it works perfectly. I appreciate your help indeed!!!

Re: [Help]macro to open file browser, to select a location, and save the location to a ce