<div>
sorry, what is cbdPrint variable?
</div>


<div>
for you Richie ;)<br />
<br />
<a href="http://buku.ti.itb.ac.id/VisualBasic5NightSchool/ch17.htm" rel="ugc">http://buku.ti.itb.ac.id/VisualBasic5NightSchool/ch17.htm</a>
</div>


for you Richie ;)

http://buku.ti.itb.ac.id/VisualBasic5NightSchool/ch17.htm [http://buku.ti.itb.ac.id/VisualBasic5NightSchool/ch17.htm]

<div>
You can also do:<br />
<br />
W.PrintOut Copies:=intNumCopies, ActivePrinter:=OutPrinter<br />
<br />
Where &quot;OutPrinter&quot; is any printer in your printers folder and this doesn't set the printer to the default.
</div>


You can also do:

W.PrintOut Copies:=intNumCopies, ActivePrinter:=OutPrinter

Where "OutPrinter" is any printer in your printers folder and this doesn't set the printer to the default.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am calling an excel template from my vb app. and printing the excel sheet as follows.<br />
<br />
xl.ActiveSheet.PrintOut<br />
<br />
xl is excel object and everything is working fine with this statement, but I need to display the print dialog box to the user, so that the user can specifiy number of copies, paper settings, etc.<br />
<br />
How do I display print dialog box?<br />
<br />
Thanks for any ideas.<br />
<br />
Chandu<br />
<br />

</div>
</div>


Hi,

I am calling an excel template from my vb app. and printing the excel sheet as follows.

xl.ActiveSheet.PrintOut

xl is excel object and everything is working fine with this statement, but I need to display the print dialog box to the user, so that the user can specifiy number of copies, paper settings, etc.

How do I display print dialog box?

Thanks for any ideas.

Chandu



VB and Excel

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.