Access to MS Excel-Table

[Rene Schuermann]

Can anyone tell me how I can get access to an
Excel-Cell Value ?
What sort of Application shall I make ? (Do I need DAO ?)

Regards R.Schuermann

[Fabi Pantera]

Why don't you use an automation client witch call the Excel server. You need to import the Type library for excel and that all (in few words).
let me know if this works fine for you or you need help.
Best regards,
Faby

[Rene Schuermann]

Hi Faby

Never heard about the Excel Server, could you please give me more information about it.

Regards Rene

[Fabi Pantera]

How about OLE Automation? Did you heard it? If you don't, try the followings :
1. Import the type library (from Class Wizard-Add Class->From a type library. Go to your office folder and try to load "excel8.olb"). You should be able to see in your class view some excel interfaces.
2. Get a pointer to a dispatch using :
IExcel8Application iApp;
iApp.CreateDispatch("Excel8.Document");
After this you can call any method from excel interfaces. Let me know if it works fine for you. (Note: try reading something about OLE Automation first. It's not so easy as it seem to be).
Best regards,
Faby