09-24-2018 01:08 PM
Ben64,
I know this is an old thread, but i came across this solution while trying to troubleshoot a similar issue. In my scenario I have a chart tab that I'm trying to export as a .png. The png file is created in the correct path with the correct name, but seemingly is an empty file. My code is a mostly a replica of what you posted as the solution and i can attach that as well if need be. I appreciate any info you can give. Thanks!
09-24-2018 03:13 PM
09-25-2018 12:22 PM
I index by the chart tab name and no there isn't an error. Everything appears to work correctly aside from the exported png containing any data. Attached is my code that opens an excel workbook and exports the chart as a png.