Macro for exporting charts and objects as jpg

[#1]

Hi,

I need to export charts as jpeg. I have this script today:

Sub ExportImageEmail 

          ActiveDocument.GetSheetObject("CH59").Activate 

          ActiveDocument.GetApplication.WaitForIdle 

          ActiveDocument.GetSheetObject("CH59").ExportBitMapToFile "BUSINESS_TEST.JPG"

I can able to export chart successfully when I am reloading the application, but the same is not exporting when I am scheduling / reloading the application through windows batch file(Command prompt).

Kindly help.

Thanks.