Export to excel doesn't work from scheduler.

[amars]

Hi,

I have a macro which export's some data (post reload Export) and stores it for user's at a particular location.

Now the user has requested us to change the name of file. I changed the name of the file to be exported in the Macro.

Now when the dashboard get's reloaded no file is getting generate/exported.

The format of the macro is

set obj = ActiveDocument.GetSheetObject("CH69")

obj.ExportBiff "D:\QV_Output\Data-" & year(date()) & right("0"&month(date()),2) & right("0"&day(date()),2) &  ".xls"

does anybody have faced such an issue. Kindly let me know.

Thanks & Regards

Amar