Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Russell Hill
  Where is Russell Hill?
 Sydney
 Australia
 Russell Hill
 To: zakaria hamieh
  Where is zakaria hamieh?
 beirut
 Lebanon
 zakaria hamieh
 Tags
Subject: RE: New page in excel sheet
Thread ID: 365474 Message ID: 365476 # Views: 44 # Ratings: 0
Version: Visual FoxPro 9 Category: Microsoft Office Automation
Date: Wednesday, December 26, 2012 8:56:59 PM         
   


> dear experts
>
> so long not being here
>
> i have time sheet for eployees that i need to print it in excel
> what i need is how to make a page break between employees so each employee will be printed on seperate page
>
> b.regards
> zakaria
> foxes will always be running

I assume you mean by Excel Automation, in which case something like this:

oExcel.Cells(whatRow,1).Select
oExcel.ActiveWindow.SelectedSheets.HPageBreaks.Add(oExcel.ActiveCell)

HTH.

ENTIRE THREAD

New page in excel sheet Posted by zakaria hamieh @ 12/26/2012 6:54:20 PM
RE: New page in excel sheet Posted by Russell Hill @ 12/26/2012 8:56:59 PM