Browse for a folder

[Erick]

I have vb code where half way through, it saves a copy of a workbook using the 'save as' command. Is it possible when I get to this part of the code for a folder browser to come up so that the user can manually point to the folder he/she wants to save the file into and then click 'ok' and the macro will then save the workbook and continue with the code?

 

[staffie007]

Hey,

Try using the

application.Dialogs(xlDialogSaveAs).Show

command... It might be what you are looking for.

Jason

 

[DominicB]

Good morning Erick

If you are using Excel 2002 or higher, try looking in the help at the GetDirectory instruction.

HTH

DominicB