open Excel sheet via VC++

[yaishb]

hello to all of u,
how can i open an existing Excel sheet via automation (what r the appropriate classes ?) ?

millions thanks.

[Alexandrov Alex]

Use CreateFileMoniker, then BindToObject.

Alex.

[Andrushok]

Hi!
I have seen a lot of smart book, which describe OLE Automation. They have examples for automating Excel. Unfortunately, it does not work. I tryed do it, but... Too many bugs here. May be the examples was old and the bugs are fixed now. It was 3 years old.

If you are interested in it yet, I can try to find one of the exaples and print here. As I remember, it is not big.

[c manish]

Hi yaishb,
U need to make automation client for that. Get the guid of the excel object. using this guid make the object of the excel sheet. Then using this pointer u can access the excel sheet methods. {Read how to make automation client in VC++)
If this help you anyway kindly rate the post.

bye,

Manish Chaudhari

[fblaha]

Take a look here:

http://support.microsoft.com/support.../Q186/1/22.ASP