ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Getting and setting all printer driver features supported using VBA (https://www.excelbanter.com/excel-programming/379567-getting-setting-all-printer-driver-features-supported-using-vba.html)

[email protected]

Getting and setting all printer driver features supported using VBA
 
Hi

I am trying to print from within Excel to a thermal transfer barcode
printer. Is there a way I can pro grammatically determine all the
options that the printer driver provide and set them using VBA.

My workbook container many sheets and all of them prints to normal
laster printer. Only one sheet need to print to this particular barcode
printer. The printer has some particular label sizes (not standard A4,
A3, Legal types) and I need to set that using VBA.

So in essence I need to figure out the label/paper sizes supported in
the printer driver. Can anyone help me?

I ready around a bit..but I could not find anything that would list ALL
available options of a printer driver..or at least paper/label sizes
supported by that printer.

Thanks in advance


ilia

Getting and setting all printer driver features supported using VBA
 
http://msdn.microsoft.com/archive/de...softAccess.asp

wrote:
Hi

I am trying to print from within Excel to a thermal transfer barcode
printer. Is there a way I can pro grammatically determine all the
options that the printer driver provide and set them using VBA.

My workbook container many sheets and all of them prints to normal
laster printer. Only one sheet need to print to this particular barcode
printer. The printer has some particular label sizes (not standard A4,
A3, Legal types) and I need to set that using VBA.

So in essence I need to figure out the label/paper sizes supported in
the printer driver. Can anyone help me?

I ready around a bit..but I could not find anything that would list ALL
available options of a printer driver..or at least paper/label sizes
supported by that printer.

Thanks in advance



[email protected]

Getting and setting all printer driver features supported using VBA
 
ilia...Thanks a lot...that look like what I was looking for...it is a
bit dense for a relative newbie like me...but I guess it is worth the
time learning it..


ilia wrote:
http://msdn.microsoft.com/archive/de...softAccess.asp




All times are GMT +1. The time now is 05:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com