script to run the macro from Vb script with out opening the excel file

[chandanp]

i have the rewuirement like runing the excel macro with out opening the excel file so i have written the following code it is working fine but the excel file is opening , which should not happen.

Dim objExcel
Set objExcel = CreateObject("Excel.Application")
With objExcel
  .Workbooks.Open ("U:\test.xlsm")
  .Visible = True
  .Run "testing"
  .ActiveWorkbook.Close(True)
  .Quit
End With

can any one pls advice.