Can we see your code?
It's really no big deal:
- I save the current ActivePrinter and PrintArea in two temporary variables.
- Change the ActivePrinter to the Microsoft XPS printer
- Change the PrintArea to the range I want to print.
- Do the Worksheet.PrintOut
- Reset the ActivePrinter and original PrintArea back from the temporary
variables.
Simple as that, but I still don't like relaying on an external printer, and
was wondering, if there was some sort of 'Export to XPS' as there are with
..PDF?
CE
---
Denne e-mail er fri for virus og malware fordi avast! Antivirus beskyttelse er aktiveret.
http://www.avast.com