I'm using Macros to generate 3 files after reload. So I have 3 Macro Triggers On Post Reload. Problem I have is that .jpg files are not exported, but .html is. My Macro is as follows:
function saveHTML()
set cs = ActiveDocument.GetSheetObject("CH14")
cs.ExportHtml "E:\ssh\data\AppStoreSales.html"
set cs = nothing
end function
sub Export1
set obj = ActiveDocument.GetSheetObject("CH09")
obj.ExportBitmapToFile "E:\ssh\data\CH09.jpg
end sub
sub Export2
set obj = ActiveDocument.GetSheetObject("CH10")
obj.ExportBitmapToFile "E:\ssh\data\CH10.jpg"
end sub
As reload is scheduled with .bat file from Windows tasks, then it should work, am I right?
When I reload template manually then all three files are generated.
I am not familiar with Macros and appreciate any help. What should I change?
I had similar problem with .JPG format in the past. Have you tried to export image as BMP instead of JPG? Here is the post on how to export the images.
Thank you for your answer. I did try .BMP format and unfortunately the situation is same. When I open document and choose reload then new files are created, but not when reload is triggered by .bat file.
