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.
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
