Haw to add PageBreaks to excell worksheet.

Andrzej

Hi,
I've prepared excell worksheet using ExcellBuf.
To meet the requirements should have Page Breaks.
Is any method to ad it using CA/L ?

Slawek_Guzek

Hi,

Start from recording a macro in Excel inserting a page break at a certain position.

It will give you a sniplet of VBA code, which you will need to replicate in C/AL, using relevant automation objects or DotNet vars.

Regards,
Slawek

Andrzej

Thanks for sugestion.

I've got samthing like this in VB:

Set ActiveSheet.VPageBreaks(1).Location = Range("Q1")
Set ActiveSheet.HPageBreaks(1).Location = Range("A90")

whitch .net libreary and function can I use to do it in CA/L ?
Sorry for question but I'm begginer in .net