Error in script??

[snapper1969]

Hi,

The following script is getting the folloing error:

Microsoft VBScript runtime error 40040
Unknown Runtime error
Line 6, Column 2


VBSTART
Sub OpenAndRun(xlFileName, MacroName)
Set xlApp = CreateObject("Excel.Application")
xlApp.visible = false
Set xlBook = xlApp.WorkBooks.Open(xlFileName)
xlApp.Run(MacroName)
End Sub
VBEND

VBRun>OpenAndRun,C:\Temp\Sally\Somerfield Commission.xls,Main
VBRun>CloseExcel

Anybody got any ideas?.

Thx,

John

[snapper1969]

I've managed to sort it. The problem lay in the Macro in excel!!