I work in a reasonably large company (250+ employees).

Management has decided to implement style standards -
including excel chart standards.

I have produced the required charts and have them saved as
custom charts on my PC. I now have to distribute them
throughout the company. I can't just overwrite the
existing xlusrgal.xls, as some people have already created
some custom charts for themselves.

If I can write an executable that will copy the charts
from my xlusrgal.xls (which will be put in a standard
network drive) into the xlusrgal.xls on each users drive,
then the system administrators can get the executable to
run on each PC to do the update.

So I need to write the executable. I could write it in VB
(I have the experience required), but am concerned about
having the required dll's etc on the user's PCs.

Has anyone else ever done this, or does anyone simply have
any ideas about how it might best be done.

Thanks in Advance.
Derek

Derek,

Need dll's be involved?

If this is a one off could you ask relevant users
(presumably not all 250) to update their own xlusrgal.xls

If that's viable, distribute a file with sample
chartsheets with a macro something like this

Sub UpdateCharts()

Dim ChName As Variant, ChTip As Variant
ChName = Array("ChartA", "ChartB")
ChTip = Array("chartA tip", "chartB tip")

For n = 1 To 2
Charts(n).Activate
Application.AddChartAutoFormat _
Chart:=ActiveChart, Name:=ChName(n - 1), _
Description:=ChTip(n - 1)
Next n
End sub

Obviously test it first.

I should add I have not this before, and I wouldn't be
surprised if someone has a better idea!

Regards,

-----Original Message-----
I work in a reasonably large company (250+ employees).

Management has decided to implement style standards -
including excel chart standards.

I have produced the required charts and have them saved
as
custom charts on my PC. I now have to distribute them
throughout the company. I can't just overwrite the
existing xlusrgal.xls, as some people have already
created
some custom charts for themselves.

If I can write an executable that will copy the charts
from my xlusrgal.xls (which will be put in a standard
network drive) into the xlusrgal.xls on each users drive,
then the system administrators can get the executable to
run on each PC to do the update.

So I need to write the executable. I could write it in
VB
(I have the experience required), but am concerned about
having the required dll's etc on the user's PCs.

Has anyone else ever done this, or does anyone simply
have
any ideas about how it might best be done.

Thanks in Advance.
Derek
.

Sandy, Derek -

This is similar to a solution I tested and posted this winter:

http://www.google.com/groups?selm=eL...40TK2MSFTNGP10

If you run the macro from the Worksheet_Open procedure, anyone who opens
the attachment will get their user gallery updated.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Sandy V wrote:
Derek,

Need dll's be involved?

If this is a one off could you ask relevant users
(presumably not all 250) to update their own xlusrgal.xls

If that's viable, distribute a file with sample
chartsheets with a macro something like this

Sub UpdateCharts()

Dim ChName As Variant, ChTip As Variant
ChName = Array("ChartA", "ChartB")
ChTip = Array("chartA tip", "chartB tip")

For n = 1 To 2
Charts(n).Activate
Application.AddChartAutoFormat _
Chart:=ActiveChart, Name:=ChName(n - 1), _
Description:=ChTip(n - 1)
Next n
End sub

Obviously test it first.

I should add I have not this before, and I wouldn't be
surprised if someone has a better idea!

Regards,


-----Original Message-----
I work in a reasonably large company (250+ employees).

Management has decided to implement style standards -
including excel chart standards.

I have produced the required charts and have them saved

as

custom charts on my PC. I now have to distribute them
throughout the company. I can't just overwrite the
existing xlusrgal.xls, as some people have already

created

some custom charts for themselves.

If I can write an executable that will copy the charts

from my xlusrgal.xls (which will be put in a standard

network drive) into the xlusrgal.xls on each users drive,
then the system administrators can get the executable to
run on each PC to do the update.

So I need to write the executable. I could write it in

VB

(I have the experience required), but am concerned about
having the required dll's etc on the user's PCs.

Has anyone else ever done this, or does anyone simply

have

any ideas about how it might best be done.

Thanks in Advance.
Derek
.