problem running macro from schedule task

[nuExcel]

hi,

plzzzzz help me...... i'm having problem of accessing my macr
("MacroHDRoster") from schedule task. The macro is kept in the Persona
Macro workbook. i've have created a file with the following code an
saved as "RunHDMacro.vbs".....

Const xlName = "C:\Documents anSettings\nunguyen\Applicatio
Data\Microsoft\Excel\XLSTART\PERSONAL.xls"
Dim xl, Wbk
Set xl = WScript.CreateObject("Excel.Application")
Set Wbk = xl.Workbooks.Open(xlName)
xl.Run "MacroHDRoster"
Wbk.Save
Wbk.Close False
xl.Quit
Set xl = Nothing

..... and try to run it from schedule task

but they can find the macro.....

can someone point me in the right direction.....

 

[Michel Pierron]

Hi nuExcel,
Try with:
xl.Run "PERSONAL.xls!MacroHDRoster"

Regards,
MP

 

[nuExcel]

thanks for that MP ..... it works perfectly now...