Hi, i need help please.
I have a vbs file where i want to execute an excel macro on a file
i don't really know
vb as i want to execute the file via cmdline.
i have a code i got off the net but it does not work.
Can anyone please help, Thanking you in anticipation
********* Code **********
Dim objExcel, objWb
On Error resume next
sFilename = "c:\deals exceptions.asc"
'Suppress errors and warnings
Set objExcel = Wscript.CreateObject("Excel.Application")
Set objWb = objExcel.WorkBooks.Open(sFilename)
objExcel.run("C:\Documents and Settings\ismailc\Application Data\Microsoft\Excel\XLSTART\PERSONAL.XLS!Macro2")
objWb.Close
objExcel.Quit
objExcel.DisplayAlerts = True
Set objExcel = Nothing
Set objWb = Nothing
*****************