Bimal,

Assuming that you have an Excel object called xlApp, try

xlApp.Run "myWorkbook!myMacro"

if you want it to run automatically on opening the workbook, put the code in
teh Workbook_Open event.


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Bimal" wrote in message
m...
Is it possible to run few excel macro from VB6?
I have few macro that takes data from 4 diffrent
sheet of same workbook and then adds a report sheet
where it dumps the report(it also creats the temp
sheet 3 times and then delets the same after calculations
are over). I want to create a exe file from VB6 which
will take data from this workbook and produce the
report in the new workbook.


Will appreciate any guides or pointers as I am new in VB.
Regards,
Bimal