User selects file location

[Monica]

I have a macro that formats data and saves certain
portions of a worksheet into a csv file. The macro
prompts the user for a path to save the file to.

Instead of the user typing in the path, is there a way to
have them select it somehow...similar to what happens
when you select File - Save As from the main Excel menu?

I appreciate your feedback.

Monica

 

[Don Guillett]

a drop down box perhaps.
http://www.contextures.com/tiptech.html