Execute macro to run automatically

Hi,

I have created a macro that i want to automatically execute everyday. But for some reason when i run the below code to execute that macro it does not work. My macro name is imanimport. What i want is to open a excel spread sheet and run that macro that would create my output file. Please help????


Dim XL As Object
Set XL = CreateObject("excel.Application")
With XL.Application
XL.Visible = True
XL.Run "imanimport"
XL.Quit
End With

Set XL = Nothing

Rakshan,

Please read Ms KBA 230575. Make adjustments for your Windows of course. Good luck. J

Thanks, its exactly what i needed. Hey, is there a similar function with excel. I have a excel spreadsheet that i want to open and refresh data in the pivot table, save and close it. I have created a macro to refresh data and save that spreadsheet. Is it possible to schedule that macro to run every day at the same time and exit excel after saving it.


Thanks,
Rakshan