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

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.
--
HTH...

Jim Thomlinson


"Reg" wrote:

> 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

thanks, it got me started

"Jim Thomlinson" wrote:

> 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.
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Reg" wrote:
>
> > 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