Open Print Dialog

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ChelseaWarren - 16 Dec 2007 09:47 GMT

Some time ago I created a macro that would open the print dialog box. I
placed it on my toolbar, but I accidently reset the toolbars and can't
remember how I created that macro.

Can anyone help?

Thanks.

Reply to this Message

Jay Freedman - 16 Dec 2007 15:43 GMT

>Some time ago I created a macro that would open the print dialog box. I
>placed it on my toolbar, but I accidently reset the toolbars and can't
[quoted text clipped - 3 lines]
>
>Thanks.

At the simplest, all you need is

Dialogs(wdDialogFilePrint).Show

You can, if you want, pre-fill the file name box, choose the initial
folder, set the document type, and so forth. You can also use the
.Display method instead of .Show, so that the file doesn't open
automatically when the user clicks OK, but your macro gets back the
information about the chosen folder and file name and can do other
things with it. See
http://www.word.mvps.org/FAQs/MacrosVBA/WordDlgHelp.htm for
information.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.

Reply to this Message

ChelseaWarren - 16 Dec 2007 19:11 GMT

Perfect!!

That's exactly what I needed.

Thank you!

> >Some time ago I created a macro that would open the print dialog box. I
> >placed it on my toolbar, but I accidently reset the toolbars and can't
[quoted text clipped - 22 lines]
> Microsoft Word MVP FAQ: http://word.mvps.org
> Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.

Reply to this Message