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
.