Select your chart object or sheet
ALT+F11 (takes you to VBE)
CTRL+G (open immediate window)
Enter the following syntax, changing path, filename and filter type as
required.
activechart.Export "C:\temp\mychart.tif","tif"
Press Return to execute command.
I was able to export an Excel chart to an image file. So without further ado, in the interest of full disclosure, here is my progress so far:
No comments:
Post a Comment