Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to choose a printer and send a file to this printer?

Status
Not open for further replies.
Paco75

Paco75

Programmer
Oct 11, 2001
239
US
Hi,

I need to get a dialog box to choose a printer then after the printer has been selected send a file to the choosen printer.

waiting for your replies :) ... thanks
 
Sort by date Sort by votes
Application.Dialogs(wdDialogFilePrintSetup).Show

Asjeff
 
Upvote 0 Downvote
I forgot to specify Im in excel... It look like wdDialogFilePrintSetup is not valid in excel. Where can I get a list of the dialog we can use? It could be useful later!

thanks
 
Upvote 0 Downvote
Get the list by searching for help, within VBA, on
"built-in dialogs"
Rob
[flowerface]
 
Upvote 0 Downvote
Application.Dialogs(xlDialogPrinterSetup).Show

Asjeff
 
Upvote 0 Downvote
It works but only with excel sheets. Can I send another file like a PDF file?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

K
  • Locked
  • Question
How to resolve define worksheets array
Replies
1
Views
584
combo
combo
feipezi
  • Locked
  • Question
How to make a recorded Excel macro (convert a text file to a Workbook) more efficient?
Replies
11
Views
533
SkipVought
S
Andrzejek
  • Locked
  • Question
Copy data between SQL and Oracle 1
Replies
8
Views
842
remeng
remeng
sal21
  • Locked
  • Question
scrping in listbox in a web page
Replies
0
Views
458
sal21
sal21
AncientTiger
  • Locked
  • Question
How to screenshot a userform and save the capture as JPG 1
Replies
7
Views
1K
AncientTiger
AncientTiger

Part and Inventory Search

Sponsor

Back
Top