Excel VBA - Load Chart templates

Posted on 2012-09-13
Last Modified: 2012-09-24
Hi Guys,

I have a excel spreadsheet that manipulates some data and produces a few charts which are based on some chart templates. This works fine on my machine but obviously not on other machines as they don't have the chart templates loaded. I have distributed the chart templates with the excel spreadsheet in the same folder and tried using code like below to load it.
ActiveChart.ApplyChartTemplate("Quality.crtx"). This works on my machine but I have already got the templates loaded.
Is there a way using VBA to load the templates automatically or is it a manual process each user will need to perform before it can be used


Question by:victoriaharry
    1 Comment
    LVL 17

    Accepted Solution

    When the template has been copied to the drive of the user, you should be able to load/apply the template chart by the following code:    

    ActiveChart.ApplyChartTemplate ("C:\Charts\Quality.crtx")

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Many companies are making the switch from Microsoft to Google Apps ( Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
    This collection of functions covers all the normal rounding methods of just about any numeric value.
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now