save panel as picture

[sruly]

Hi James..

Listen, I found the Command who sets me the page break in Excel but when I press F1 I dont have the help on the commands ..

I need you to tell me(if u can) what parameter I need to insert to "BEFORE" on Excel_HPageBreakAdd command.

Thank u

Sruly.

[James M]

Hi Sruly,

As you know, the Excel_HPageBreaksAdd function is part of the Microsoft Object Library which is automatically generated from the functions exposed by the Excel ActiveX server. While the functions definitions are exposed by the server, Microsoft does embed any documentation in the server itself. Instead, you must rely on the MSDN help on microsoftc.com. The documentation for the HPageBreaks collection can be found here. If you follow the link to the add function, you will notice the following comment:
Before  Required Object. A Range object. The range above which the new page break will be added.

Again, please understand that the use of these methods and their corresponding documentation is Microsoft specific (not related to CVI).

Regards,

[ebalci]

Hi,

I have been using the VBAXL10.CHM file as an offline help for some time and it is helpful. It is for using the Excel API under VBasic, I think, but I find useful information most of the time. It is in the folder C:\Program Files\Microsoft Office\OFFICE11\1033 on my PC.

I do not know why, but when copied outside this folder. The file appearance changes when I click the links. So you'd better open it from the folder it is installed.

[sruly]

Hi,

I understand that the use of these methods and their corresponding documentation is Microsoft specific (not related to CVI),

But, I'm stuck here and I need to finish that job and you are the only one who can help me..

So, any help will be appreciated...

I guessed that too ,that Before  Required Object. A Range object. But I'm getting Error when I try to use this function.

Please tell me what i'm doing wrong...

static ExcelObj_Range              ExcelRangeHandlePB = 0;
 

    error = CA_VariantSetCString (&MyCellRangeV, "A36");
    error = Excel_WorksheetRange (worksheet, NULL, MyCellRangeV, CA_DEFAULT_VAL, &ExcelRangeHandlePB);
    error = Excel_RangeActivate (ExcelRangeHandlePB, NULL, &VPBreak);
    error = Excel_HPageBreaksAdd (worksheet, NULL,ExcelRangeHandlePB ,&PageBreak );

Tha last function Excel_HPageBreaksAdd return Error..

Thank u again for your help...