COM with Excel - I will fail without support.....

[chris_bdnsee]

All,

I am totally frustrated......
I thought that I had some basic knowledge about programming but I am totally lost.

I am struggling with the COM Interface of thinBasic, or to say it better I can't handle it.....

I have examined the COM example, learned something and tried to figure out a very simple task. Just open an existing xls file - well sound's easy, but I can't get it working.

So i need some smarter brain from the community.

I figured out that there is a method of the application object:

Workbooks.Open "ANALYSIS.XLS"

However my thinbasic translation:

if COM_Succeeded(COM_CallMethod(pXlApp, "Workbooks.Open Filename:=" & $DQ & "D:\thinBasic\Projekte\GraphWizard\GraphWiz_Output_v1.xls" & $DQ, 0, 0, 0)) then
MsgBox 0, "Klappt"
end if

returns always with an error of:
Error: 80020006
Desc: Unknown name
Function: GetIDsOfNames()
Member: Workbooks.Open Filename:"....
TB equate: Unavailable


Im using Win XP SP2 with Excel 2000.

Any more insight on the COM functions of thinBasic with Excel is really appreciated......

My plan is to use thinBasic as an intellegent interface between MS Access and setting up some advanced xls graphs, so I would need to go down very deep in the excel object model - but I am not sure whether thinBasic is right for me or the COM interface of thinBasic is spelled out enough for me to solve the task.....

Thank you in advance for supporting a real frustrated guy !

best regards

Christian
PS: To make one thing clear - I really like thinBasic - it's more about my missing knowledge....