Calling a 'standard' dialog

[Reg]

I am trying to automate a process and would like to be able to offer the user
the chance to choose a directory to save a refreshed worksheet in.

I am failry new to coding in Excel and whilst I can do simple things like
get a string and output the new filename I would really like to call a
standard dialog and let people choose through an interface they recognise.

I can't seem to make any of the non-VB controls work so I am guessing I have
to use a Class Module.

Can anybody point me at some examples please?

Regards
Reg

 

[Jim Thomlinson]

I am not 100% sure which dialog your are looking for, but if you type in
application.Dialogs(
you will get an intellisence listing of all of the dialogs.

 

[Reg]

thanks, it got me started

I am not 100% sure which dialog your are looking for, but if you type in
application.Dialogs(
you will get an intellisence listing of all of the dialogs.