How can I change the page in writing data to excel file?

Hi,
Do you mean Page as in sheets? If yes,
Try setting the Application.ActiveSheet property to the sheet that you want to write data into (if you want to make it visible). Or you could just get a reference on the sheet by using the Sheets Collection in the workbook object.
ThisWorkbook.Sheets["my Sheet"]
cheers,
Paul June A. Domag

Hi BigBoy,

I am not sure if I got your question right, but in Excel there is no concept of Pages as in Word. You just keep adding rows. You would probably yourself need to define n number of rows to denote 1 page of data and accordingly add that value to skip that many rows when you write the next data.

Regards,
Vikram

Hi,

I think its based on paper size. If the other printer is also using the same paper size then I guess it would print the same number of rows.

If you are printing programmatically then you can control this.

Regards,
Vikram

Hi,

Take a look at the following sample:

Printing in VB.NET
http://www.vbdotnetheaven.com/Code/Jun2003/2087.asp

Regards,
Vikram