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