User input for current path?

I am writing a macro that will perform a loop operation to export files. I want the user to specify the path, and the macro will save each exported file to that folder.

I did a number of searches and I can't find exactly what I'm looking for.

I think I want to use ChDir after using CurDir. But I don't know how to code the macro so that it asks the user to specify the location.

Can I do something like this?

Please Login or Register  to view this content.

Thanks,
-gshock

maybe something like this to allow the user to pick folder.

Please Login or Register  to view this content.

Hi Andy,
Thanks for the suggestion. I get an 'Object doesn't support this property or method' error on this line:

Please Login or Register  to view this content.

I'm on company software and they've disabled the Tools-->References menu option. I've seen reference to this in other posts on similar topics. Not sure if this applies.

VB 6.5, Excel 2000

Thanks.
-gshock

FileDialog is not available in xl2000

You could try the BrowseForFolder example here,
http://www.oaltd.co.uk/MVP/Default.htm