ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Page breaks in Sheet for copy via OLE? (https://www.excelbanter.com/excel-programming/271281-page-breaks-sheet-copy-via-ole.html)

papou[_6_]

Page breaks in Sheet for copy via OLE?
 
Hi all
Excel 2k
I need to copy some data from Excel to Word via OLE, that is ok so far.
The problem resides in the fact that my Excel document contains several
pages (BTW: I would like to keep the same heading in my Word Doc).
I thought I would need to identify each page break in my sheet so that I
would copy each page to a new page in Word.
I have been "playing" with HPageBreaks but I can't seem to find a way to
identify precisely each of my page breaks to determine the area I want to
copy.
Can anyone help please?
TIA

Regards
Pascal




All times are GMT +1. The time now is 07:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com