How to call an Excel macro from VB6?

Ivan · Joined: 04 Oct 2007 Posts: 4

Dear all,

I need to write a VB program which calls an Excel macro but I am not sure
how to do it..... Any suggestion or reference codes?
Thanks a lot.

Ivan

Archived from group: microsoft>public>vb>ole

Changing text in MS Access Macro with VB6 Hi All, Is it possible to change the text contained in an MS Access Macro with VB6? I have previously used DAO to change permissions on MS Access Macro objects in the Scripts container but this object model does not allow me access to th

replace Excel 2000 -> Excel 2003 I am using the following code to edit data cell by cell: What:="", I get a Microsoft error "Microsoft Excel cannot find any data to replace. Check if your search formatting and criteria are defined correctly. I

Excel chart from VB to Excel Hi I've a Chart object in a VB6 form together with some text boxes, my question is can I "copy" the chart object from the form and place it in a Excel chart ?? I know I can create the chart in a Excel my question is can I

Call a ATL COM in VB that takes unsigned int as a parameter Hi I am trying to Call a ATL COM in VB that takes unsigned int as a parameter. Here is my code through which I tried to Call a COM. *I already add a refrence of th

Excel and OLE Is there any way to take an Excel object, whether it be a chart object or range, and connect it to an OLE control to show the object? For instance, if I had: Dim objApp As Dim objBooks As Dim range As Excel.range Dim objS