Calling a 'standard' dialog

  • Thread starter Thread starter Reg
  • Start date Start date
R

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
 
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.
 
thanks, it got me started

Jim Thomlinson said:
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.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using SaveAs Dialog and Changing Location 2
Dialog Box Buttons 1
Public Variables, Class Modules and Standard Modules 2
Epson XP-3150 not printing 2
Re: Reference must be to a macro sheet? 0
Can I display an open file dialog from a macro 7
Application level events - calling from standard module 2
User created Dialog Box 1

Back
Top