Search found 2 matches
- Wed Jun 27, 2007 8:39 pm
- Forum: Programming
- Topic: Here's an example of BullZip PDF generation in VBA (Excel)
- Replies: 4
- Views: 31254
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...
- Wed May 02, 2007 11:14 pm
- Forum: Programming
- Topic: Here's an example of BullZip PDF generation in VBA (Excel)
- Replies: 4
- Views: 31254
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") &...