-----------------------------------

deville75

Thu Feb 08, 2007 11:33 am


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?


-----------------------------------

Andy

Thu Feb 08, 2007 3:52 pm


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


-----------------------------------

wtd

Thu Feb 08, 2007 4:18 pm


RE:Calling macros from C++

-----------------------------------

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


-----------------------------------

deville75

Mon Feb 12, 2007 10:19 am


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?


-----------------------------------

wtd

Mon Feb 12, 2007 11:53 am


RE:Calling macros from C++

-----------------------------------

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