Code to print the data from the excel file

Question posted by: Saray (Newbie) on July 24th, 2008 12:08 PM

Hi,

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

Thanks in advance

Saray

Would you like to answer this question?
Sign up for a free account, or Login (if you're already a member).

smartchap

Member

44 Posts

July 25th, 2008
10:03 AM
#2

Re: Code to print the data from the excel file

First of all declare an object for Excel like

Dim App as Excel.Application

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

App.Sheets(1).Prnitout

Not the answer you were looking for? Post your question . . .
182,371 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).

Top Visual Basic Forum Contributors