Where is help for excel97.fp?

[btuman]

I am using excel97.fp and I am trying to view the help on some of the functions. However, I get a message saying,

"Documentation for this function, if provided by the server, is located in the function help."

and when I look at the function help it says:

":$@SYSHELP<>66219:"

Can somebody tell me what this means and how I get the help information for the fp.

Also, I am trying to import a fixed width text file into Excel. I was thinking that I could use Excel_Workbooks_OpenText, but since I cannot view the help I am not sure about this. Can anyone confirm this for me?

Thanks!

[bilalD]

Hello

These functions are wrappers that allow you to call the various properties and methods of Excel, which is an activex server. Since this is a third party server, the actual help for the functions and properties are installed with Excel. The string that you see in the help is a link to the function in the help file that is registered to the Excel Activex server. If you need more information about the functions and properties, check out the Excel help files.

Bilal Durrani
NI

[btuman]

OK. That's what I figured, but how do I get Excel to provide the help in the function panel? I looked through the help information in Excel, but I do not see anything about it.

Also, I have successfully opened a text file using Excel_WorkbooksOpenText(), but I am having another problem that I am hoping someone can help me with.

I am trying to add a new form to the workbook using Excel_ChartsAdd(), but it always produces an error and since I cannot see the help information, I am not sure that I am using the function correctly. I am calling it as follows:

// Create a new sheet for the chart
status = Excel_ChartsAdd(ExcelChartsHandle, &errorInfo, CA_DEFAULT_VAL, CA_DEFAULT_VAL, CA_DEFAULT_VAL, &ExcelChartHandle);

if (status<0) goto Error;

The sta
tus code returned is -2147467262, "No Such Interface".

How do I use this function correctly??

Thanks for your help.

[bilalD]

There are a couple of CVI examples that demonstrate how to use these functions. It's pretty extensive it the functionality it covers. You can find it under ..\cvi\samples\activex\excel

Bilal

[btuman]

I have already been through those examples. They only use the chart wizard Excel_ChartChartWizard() and that adds it right to the existing sheet in the workbook. I am looking to make a new chart sheet and make the chart there. Ideas?

[Chris Matthews]

You can get the Microsoft Help by reinstalling Microsoft Office and making sure to install the "Office Help for Visual Basic". This will install the function reference for the Office ActiveX APIs.

Best Regards,

Chris Matthews
National Instruments

[bilalD]

I got this by working off of the example, but it looks like this should work, this adds a sheet to the workbook. First get the handle to the sheets object from the application handle, then use the sheets handle to add another sheet to the workbook. It can get a little confusing sometimes since you have to get the right type of handle for the appropriate function.

error = Excel_GetProperty (ExcelAppHandle, NULL, Excel_AppSheets, CAVT_OBJHANDLE,
&ExcelSheetsHandle);

if (error<0)
goto Error;

error = Excel_SheetsAdd (ExcelSheetsHandle, NULL, CA_DEFAULT_VAL,CA_DEFAULT_VAL, CA_DEFAULT_VAL, CA_DEFAULT_VAL, &newSheetHandle);

Hope this helps

Bilal

[btuman]

Thanks. However, I can already add a new sheet without a problem. I am having the problem adding a new chart using Excel_ChartAdd(), not Excel_SheetAdd().

I'll keep at it...must be something minor that I'm missing somewhere. But everything seems right...

Brian