Computer Science Canada

Calling macros from C++

Author:  deville75 [ Thu Feb 08, 2007 11:33 am ]
Post subject:  Calling macros from C++

My program needs to open up an excel file and call a macro within it. Basically the excel file will have data. The macro will graph this data. I want my program to be able to open the file, call the macro and therefore display the graph. Does anyone know how to do this?

Author:  Andy [ Thu Feb 08, 2007 3:52 pm ]
Post subject:  Re: Calling macros from C++

why do you need to do it with C++? Unless its absolutely necessary, i'd suggest to using PERL, it'll make things ALOT simpler

Author:  wtd [ Thu Feb 08, 2007 4:18 pm ]
Post subject:  RE:Calling macros from C++

Ruby and Python would also work. They both have Win32 OLE bindings. A great many languages do.

Author:  deville75 [ Mon Feb 12, 2007 10:19 am ]
Post subject:  RE:Calling macros from C++

I've already completed my application in C++. I don't want to start all over in another language. Also it's sort of required for me to use C++ anyway. So is there a way for me to call the Macro in Excel?

Author:  wtd [ Mon Feb 12, 2007 11:53 am ]
Post subject:  RE:Calling macros from C++

Google the following terms: c++, win32, ole, excel


: