Search found 2 matches

by jce
Wed Jun 27, 2007 8:39 pm
Forum: Programming
Topic: Here's an example of BullZip PDF generation in VBA (Excel)
Replies: 4
Views: 29161

VBA Printing

Here's a link where you can enumerate your printers: http://support.microsoft.com/kb/q166008/ Then you have to add " on Ne??:" where ?? is the number of the printer in the order that they are enumerated in. (01, 02, etc.) Once you have an enumerated list of all your printers' full names in a VBA arr...
by jce
Wed May 02, 2007 11:14 pm
Forum: Programming
Topic: Here's an example of BullZip PDF generation in VBA (Excel)
Replies: 4
Views: 29161

Here's an example of BullZip PDF generation in VBA (Excel)

Here's an example of a BullZip PDF generation macro in VBA for Excel, if anyone's interested. [code] Sub PrintSheetAsPDFwithBullZip() 'must add a reference to BullZip Dim myobject As New Bullzip.PDFPrinterSettings Dim SavePath As String, FileName As String SavePath = Environ("HOMEDRIVE") & Environ("...