• can I create a jpg or gif from an Excel chart using VBA?

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » can I create a jpg or gif from an Excel chart using VBA?

    Author
    Topic
    #483217

    Aloha all,
    I’m looking for a way to automate a process that is manual and tedious. The process: I select a range of cells surrounding an embedded chart in an Excel spreadsheet, copy, switch to a graphics app like Paint, paste, and save as a jpg. I have to do this several hundred times. Is there any way to Save As a jpg from within Excel? Or using VBA in another Office app?
    Mahalo for your suggestions,

    John Jacobson

    Viewing 0 reply threads
    Author
    Replies
    • #1332334

      I don’t think there is a direct way to do this, but you can select the chart and use a line of code like:
      ActiveChart.Export “C:MyPathChart.jpg”

      Steve

    Viewing 0 reply threads
    Reply To: can I create a jpg or gif from an Excel chart using VBA?

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: