Run excel macro through vbs

[davethegog]

I'm trying to open an excel file and subsequently run an excel macro through a vbs file. I've got this far but can't seem to finish off.

Set objExcel = createobject("Excel.application")
objexcel.Visible = True
objexcel.Workbooks.open "c:\training 2.xls"
objexcel.application.run macro ="test"
objexcel.Quit

Any suggestions would be appreciated.

 

[PHV]

Have you tried this ?
objexcel.Application.Run "test"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[davethegog]

cheers

 

[cspm2003]

Hi, thx to both of you, taht was pretty helpfull