Using VB (Excel) Commands

Hi,

I want to write a C++ program that interacts with Excel.
I have used the VB edit from within Excel in past, and want to be able to access or use workbook functions such as 'Workbooks.Open' but in a C++ program.

Can I used these functions? or are the equivelent C++ functions to achieve the same thing?

I am using MS Visual Studio 6.00


Thanks

You could make your own object... still it would be a mess...

1. This is windows specific (moved)
2. This involves using COM
3. I think Ken Fitlike has posted some examples of how to do this in the past - try searching the board.

Check out DispHelper