Code to print the data from the excel file

[Saray]

Hi,

Can you please give me a sample code to print the data to the printer from the excel sheet.


Thanks in advance


Saray

[smartchap]

First of all declare an object for Excel like

Dim App as Excel.Applicati on

in general section. then after opening the sheet and setting App to point that workbook use command like

App.Sheets(1).P rnitout