G
Gerrit Kiers
Hi
I'm creating a type of auto-graph routine in VBA Excel 2000 and I want
it to remain very flexible. So I decided that I would code only very
limited graph formatting.
I came up with a concept that uses user-defined graphs (build-in
capacity of Excel). During the execution of the macro one can select
from a combobox from the list of user-defined graphs and the selected
will be applied. Of course the user is encouraged to add own
user-defined graphs.
Since I am dealing with time-line graphs this concept has the big
advantage that I can refrain from using any date-formatting!
I still have several questions:
I might seem stupid, but I have been looking for a way to load the
combobox without opening the file.
For Each GraphObject in Workbooks("xlusrgal.xls")
would not work, since the file is no member of Workbooks.
Is there a method that I can use or do I really have to open the file
to read out the ChartObjects Collection?
How do I define the path of the "xlusrgal.xls" file, using system
variables, so that it is easy to find, no matter wether Win9x or NT
etc. (root/.../application data/..../MS/Excel/)
And I still have a doubt whether it is a good idea to use the native
"xlusrgal.xls" for this storage opposite to creating my own template
collection. But then: How do I store and retrieve? With Copy and
Paste? What would be wise?
Thanks! Gerrit
I'm creating a type of auto-graph routine in VBA Excel 2000 and I want
it to remain very flexible. So I decided that I would code only very
limited graph formatting.
I came up with a concept that uses user-defined graphs (build-in
capacity of Excel). During the execution of the macro one can select
from a combobox from the list of user-defined graphs and the selected
will be applied. Of course the user is encouraged to add own
user-defined graphs.
Since I am dealing with time-line graphs this concept has the big
advantage that I can refrain from using any date-formatting!
I still have several questions:
I might seem stupid, but I have been looking for a way to load the
combobox without opening the file.
For Each GraphObject in Workbooks("xlusrgal.xls")
would not work, since the file is no member of Workbooks.
Is there a method that I can use or do I really have to open the file
to read out the ChartObjects Collection?
How do I define the path of the "xlusrgal.xls" file, using system
variables, so that it is easy to find, no matter wether Win9x or NT
etc. (root/.../application data/..../MS/Excel/)
And I still have a doubt whether it is a good idea to use the native
"xlusrgal.xls" for this storage opposite to creating my own template
collection. But then: How do I store and retrieve? With Copy and
Paste? What would be wise?
Thanks! Gerrit