H
Hmtwngrl
I want Access to make the Excel Charts automatically. Is this possible?
If so, how?
If so, how?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
Larry Daugherty
Yes, it's possible and done all of the time. Look in Access' Help for
"Automation".
HTH
"Automation".
HTH
H
Hmtwngrl
Could you be more specific? When I type in Automation, I am not getting
anything except VBA direction. No help on how to get started. Is there a
tutorial? I have Access 2003.
anything except VBA direction. No help on how to get started. Is there a
tutorial? I have Access 2003.
L
Larry Daugherty
There really is no more Help than that. I seem to recall someone,
somewhere raving on about using the various Office platforms in
client-server relationships but don't recall the specifics. The
concept is simply that VBA is a common language across the platforms
and that the various platforms expose object libraries. Learn how to
program the target platform natively. Move that VBA code over to the
client platform, with appropriate object declarations and run it from
there.
In the issue that you've raised, create the VBA macros in Excel to do
exactly what you want. When that works properly, move the code over
to Access and make it work under program control.
HTH
somewhere raving on about using the various Office platforms in
client-server relationships but don't recall the specifics. The
concept is simply that VBA is a common language across the platforms
and that the various platforms expose object libraries. Learn how to
program the target platform natively. Move that VBA code over to the
client platform, with appropriate object declarations and run it from
there.
In the issue that you've raised, create the VBA macros in Excel to do
exactly what you want. When that works properly, move the code over
to Access and make it work under program control.
HTH