Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print a range to a XPS document?
Hi guys,
Do any of you have a example code for printing a range to a XPS document? I'm struggling with it, but can't make it work... ....well, it (kind of) works, but I'm not pleased with the (workaroud) way I'm using, and was wondering if someone know of a cool/proper way of doing it? Thanks, CE --- Denne e-mail er fri for virus og malware fordi avast! Antivirus beskyttelse er aktiveret. http://www.avast.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print a range to a XPS document?
Can we see your code?
-- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print a range to a XPS document?
Perhaps you'll find something useful here...
http://www.rondebruin.nl/win/s5/pdf.htm -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print a range to a XPS document?
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print a range to a XPS document?
Thanks, Garry, but that applys to PDF, and I prefer XPS :-)
CE "GS" wrote in message ... Perhaps you'll find something useful here... http://www.rondebruin.nl/win/s5/pdf.htm -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion --- Denne e-mail er fri for virus og malware fordi avast! Antivirus beskyttelse er aktiveret. http://www.avast.com |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print a range to a XPS document?
Thanks, Garry, but that applys to PDF, and I prefer XPS :-)
You can specify XPS in place of PDF for the output type as since Excel 12 both formats are available. -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I PRINT EVERY OTHER PAGE OF A DOCUMENT? | Excel Discussion (Misc queries) | |||
Document Properties sent to print when print with office applicati | Excel Discussion (Misc queries) | |||
how do i rotate a document or print small document on envelope | New Users to Excel | |||
how can I delete the print box that pops up to show document print | Excel Discussion (Misc queries) | |||
VBA to print Word Document | Excel Programming |