printing via vba

  • Thread starter Thread starter neowok
  • Start date Start date
N

neowok

I have this which is in a bit of code activated by a button.

Charts("Overall Days By Period").PrintOut

but this just prints straight out to whatever printer is currentl
selected. Is there a way to change this so that it brings up th
dialog box which asks things like which printer, how many copies etc
 
hi,
Application.ActivePrinter = "\\OKI-01\OKI-HP4000-01 on
Ne01:"
Application.activePrinter would be the command.
the the server file path to the printer.
the above is from my network. you will have to find out
what your's is.
Regards
Frank
 
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

If no default printer Open Print Diablog box 2
Printing 1
How to read settings from xlDialogPrint 1
Print macro using xlDialogPrinterSetup fails to use driver-specific settings 0
Get Control Before AND After Printing 1
User select printer in print macro 7
Print All Sheets-Select Printer First 3
printing via vba 1

Back
Top