Page breaks in Sheet for copy via OLE?

P

papou

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Section and Page numbering 0
Mail Merge Directory Conditional Page Break 0
MS Word Page Layout/Break/Margin Issues, help 0
problem with finding horizontal page breaks 7
White space above heading inconsistently applied 1
Auto Merge text from multiple sources 0
Converting excel to PDF, single page converts to multiple HELP! 1
Define specific page breaks when printing to PDF 0

Top