Excel VBA - Load Chart templates

Posted on 2012-09-13
Medium Priority
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

ExcelGuide earned 2000 total points
ID: 38397862
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

839 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