Macro to Export Charts as PNG

**JFERG** · 08-14-2014, 07:53 AM

Hi all,

I am new to macros and I am trying to export 20 charts that are one worksheet. I found the code below online and it it does work for a majority of the charts. However, it randomly skips some of the charts and does not export the. I recevie an Run Time error 76; Path not found. Each chart is named. Any ideas? Thank you
Justin

Sub Create_Png()

Dim objCht As ChartObject
Dim strPath As String

strPath = "C:\Path Name"

For Each objCht In ActiveSheet.ChartObjects
objCht.Chart.Export strPath & objCht.Name & ".png", FilterName:="png"
Next

End Su

**Andy Pope** · 08-14-2014, 08:10 AM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Please Login or Register  to view this content.

I assume the folder 'Path Name' exists?
Is it really skipping charts or is it possible the chart name for multiple objects is the same?

Macro to Export Charts as PNG

LinkBack

Thread Tools

Rate This Thread

Display

Macro to Export Charts as PNG

Re: Macro to Export Charts as PNG

Thread Information

Users Browsing this Thread

Similar Threads

Export charts from an excel file as images and name the image files by the charts title

change order of graphs when using macro to export all excel charts to powerpoint

Export excel2000 charts into EMF/WMF

Excel should let me export charts as .eps or .png

export charts

Bookmarks

Bookmarks

Posting Permissions