<div>
Hi kirtirani,<br />
<br />
or use the shellexecute function<br />
<a href="http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q238245&" rel="ugc nofollow">http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q238245&</a><br />
<br />
this line <br />
<br />
StartDoc = ShellExecute(hwnd, &quot;open&quot;, &quot;C:\My Documents\Book1.xls&quot;, &quot;&quot;, _<br />
&nbsp; &nbsp; &nbsp; &quot;C:\&quot;, SW_SHOWNORMAL)<br />
<br />
change the open to print like<br />
<br />
StartDoc = ShellExecute(hwnd, &quot;print&quot;, &quot;C:\My Documents\Book1.xls&quot;, &quot;&quot;, _<br />
&nbsp; &nbsp; &nbsp; &quot;C:\&quot;, SW_SHOWNORMAL)<br />
<br />
HTH:O)Bruintje
</div>


Hi kirtirani,

or use the shellexecute function
http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q238245& [http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q238245&]

this line

StartDoc = ShellExecute(hwnd, "open", "C:\My Documents\Book1.xls", "", _
      "C:\", SW_SHOWNORMAL)

change the open to print like

StartDoc = ShellExecute(hwnd, "print", "C:\My Documents\Book1.xls", "", _
      "C:\", SW_SHOWNORMAL)

HTH:O)Bruintje

<div>
reason to use shell to print is that if you close and quit excel while printing you'll get an error because you're trying to throw an object while it's still busy
</div>


reason to use shell to print is that if you close and quit excel while printing you'll get an error because you're trying to throw an object while it's still busy

<div>
<div class="content wysiwyg-content">
Hi,<br />
I am doing some excel programming. I have one form with some text boxes. there are 2 commnads button.<br />
Submit button :- submits the changes from the text boxes to particular cells of excel sheet.<br />
Print button :- I want to print the excel sheet as soon as i click the print button.<br />
Can anyone tell me how to do the print button's printing part????<br />
Kirti
</div>
</div>


Hi,
I am doing some excel programming. I have one form with some text boxes. there are 2 commnads button.
Submit button :- submits the changes from the text boxes to particular cells of excel sheet.
Print button :- I want to print the excel sheet as soon as i click the print button.
Can anyone tell me how to do the print button's printing part????
Kirti

How to print an excel sheet?

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.