Open Template with file picker

[rob0923]

Hi,

I think I found something regarding a file picker to open up a template that was written by Ken Puls, but I can't seem to find the thread again.

I am looking to have a file picker box pop up to allow a user to choose the template (Any Name) from any location, rather then have it stationary. I would like this because I am going to have a variety of templates and don't want to set to many macros to run each template.

Thanks in advance!

[GTO]

Greetings Rob,

I found only two articles that included Application.FileDialog.

http://www.vbaexpress.com/kb/getarticle.php?kb_id=1042

http://www.vbaexpress.com/kb/getarticle.php?kb_id=896

Mark

[Bob Phillips]

Take a look at help, there is a good(ish) FileDialog exmple there.