PDA

View Full Version : Open Template with file picker



rob0923
10-01-2009, 05:21 PM
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
10-01-2009, 08:56 PM
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
10-02-2009, 01:40 AM
Take a look at help, there is a good(ish) FileDialog exmple there.