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.....

--
Message posted from http://www.ExcelForum.com