User selects file location

M

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
 
Top