Search found 4 matches

by louiekw
Wed Apr 10, 2013 4:26 pm
Forum: Programming
Topic: VBA printing PNG - Dialog PopUp problem
Replies: 2
Views: 81704

VBA printing PNG - Dialog PopUp problem

Dear All, I have written a VBA to print 3 pages of Excel Sheet to PNG files. However, sometimes the print dialog is displayed after printing the 3 excel sheets. I cannot discover the triggering conditions. Sometimes the last page png is not export. What is the problem? Deallocation of Object? or any...
by louiekw
Tue Apr 09, 2013 5:52 am
Forum: Programming
Topic: Bullzip printer Dialog shown up after print using VBA
Replies: 0
Views: 65617

Re: Bullzip printer Dialog shown up after print using VBA

Anyone can help to solve this problem?
by louiekw
Sat Apr 06, 2013 6:26 am
Forum: Programming
Topic: VBA - Print Dialog popup after print PNG
Replies: 0
Views: 62002

VBA - Print Dialog popup after print PNG

Dear All, I have written a VBA to print 3 excel sheets to PNG. However, the print dialog shown up after printing the third sheet. What is the problem? Public Sub PrintPNG2(FileName As String, SavePath As String, SheetName As String) Dim oPrinterSettings As Object Dim oPrinterUtil As Object Dim sFold...
by louiekw
Sat Apr 06, 2013 6:23 am
Forum: Programming
Topic: Bullzip printer Dialog shown up after print using VBA
Replies: 0
Views: 65617

Bullzip printer Dialog shown up after print using VBA

Dear All, I have written a VBA to print 3 pages of Excel Sheet to PNG files. However, the print dialog is displayed after printing the 3 excel sheets. Sometimes the last page png is not export. What is the problem? Deallocation of Object? or any other issue? Private Sub PrintSheets() PrintPNG "FileN...