The following code seems fairly useful:
Sheets("Chart1"
.Export Filename:="D:\TEMP\Test.GIF", FilterName:="GIF", Interactive:=True
Except, for a couple of nuances. I have tried other file "filters" like BMP, but they don't seem to work. I get an application runtime error. Also, the Interactive:=True does not seem to bring up any dialog box as describe in the help file.
And the part that I am grappling with the most is that I always get the same size chart (regarless of zoom setting, which sometimes messes up the rendering if set smaller or larger and there exist overlaid textboxes and/or other autoshapes like arrows): 909x670.
Is there any option available to set the GIF settings (specifically size) on export?
Thanks in advance,
Aeneas
Sheets("Chart1"
.Export Filename:="D:\TEMP\Test.GIF", FilterName:="GIF", Interactive:=TrueExcept, for a couple of nuances. I have tried other file "filters" like BMP, but they don't seem to work. I get an application runtime error. Also, the Interactive:=True does not seem to bring up any dialog box as describe in the help file.
And the part that I am grappling with the most is that I always get the same size chart (regarless of zoom setting, which sometimes messes up the rendering if set smaller or larger and there exist overlaid textboxes and/or other autoshapes like arrows): 909x670.
Is there any option available to set the GIF settings (specifically size) on export?
Thanks in advance,
Aeneas