Column Headings in all the pages in excel

shibily

Hi,
I am using excel buffer to show the some reports in excel. But how can i show the column headings in all the pages when i print/preview the excel ?

Thanks in advance
Shibily

garak

Take a look to the Page Setup and there to the last Register.
Or u use the "Header / Footer" Option.

To use this with the excel buffer, do this before:

1. Start Excel
2. start macro recording
3. do this what NAV should do (for example create a header line)
4. Stop macro recording
5. take a look to the VB-Source
6. Transfer this VB-source to C/AL code in the Excel buffer table.

It's very easy.

Regards

shibily

garak,
Thanks a lot for the reply. I tried as you said and it worked for me.
I wrote the following code to print the first row in all the pages
XlWrkSht.PageSetup.PrintTitleRows := '$1:$1';

Regards
Shibily

garak wrote:

Take a look to the Page Setup and there to the last Register.
Or u use the "Header / Footer" Option.

To use this with the excel buffer, do this before:

1. Start Excel
2. start macro recording
3. do this what NAV should do (for example create a header line)
4. Stop macro recording
5. take a look to the VB-Source
6. Transfer this VB-source to C/AL code in the Excel buffer table.

It's very easy.

Regards

garak

You're welcome