automation

[Joanne]

I really would like to find a good resource for information regarding
automation of msword thru msaccess.
These newsgroups are a huge help, most of us would be getting no where
without all of the help given freely in these groups. But mostly it is
working within an application. Finding info about automating from one
office app to another is harder to find probably because there is less
of this kind of programming going on I would assume. Even as I search
the net, using google and directory searches etc, I have trouble
finding the automation answers I need. My public library has a medium
fare amount of office literature, but again, automation just is not a
major item there either. In fact there are no books teaching
automation, only bits and pieces of automation in the books teaching
office.

Is there a book I can get, or a site I can go to, that is mainly
concerned with automation between the apps.

Thanks for the information
Joanne

 

[Albert D. Kallal]

I really would like to find a good resource for information regarding
automation of msword thru msaccess.
These newsgroups are a huge help, most of us would be getting no where
without all of the help given freely in these groups. But mostly it is
working within an application. Finding info about automating from one
office app to another is harder to find probably because there is less
of this kind of programming going on I would assume. Even as I search
the net, using google and directory searches etc, I have trouble
finding the automation answers I need.

Automaton generally requites that you have a good working knowledge of the
application. A good book on "office VBA"will have a lot of examples.

My old book of Teach yourself Visual basic for applications (office 97) was
a good book for example (It was one of those teach yourself in 21 days
books...one of many from Sams publishing)

My public library has a medium
fare amount of office literature, but again, automation just is not a
major item there either.

As mentioned, I think a book on VBA for office would be the ticket here.
Most VBA books concentrate on automaton, since that is what VBA is for.

You also don't mention what kind of automaton you are looking to do. For
example, I have some great sample code that does a word merge for you, and
it is very slick from a end user point of view. This merge library that
instantly turns a ms-access form into a "single" record merge to a word doc
of your choice. You can find the sample code here:

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html

 

[Van T. Dinh]

Seach the Microsoft Knowledge Base on:

<http://support.microsoft.com/default.aspx?scid=fh;EN-
US;KBHOWTO>

There are numerous articles on automating Word from Access.

HTH
Van T. Dinh
MVP (Access)

P.S. I didn't give links to these articles as with this
way, you learn how to use an excellent resource freely
available to you also.

 

[Joanne]

Albert
Thanks for the info. I am on my way to the book store to find a vba
for office book.
I looked at your wordmerge22.zip file - very slick. But I can't get to
the code to look at it. I noticed that your commandbar loaded right
up, but it did not disable the commandbars that I already had loaded.
At this moment, I am trying to disable msword main menu (and any other
commandbars the user may have open) and show only my menu while
working on the docs in msword, changing it back to normal on exit of
msword. I expect I need to loop thru the commandbar collection in some
way and disable any commandbars that are enabled, enable mine, then
reverse the routine on exit of word. I just don't know the syntax for
such a job, and this is where I need a good reference to vba
automation.
I have searched the kb and msdn site, google groups, and just google
in general but haven't found the method to do this yet.
So, as I said, I will follow your advice and get a good book full of
examples that will help me learn to do this with some finese.
Thanks for your time and consideration of my question.
Joanne

 

[Albert D. Kallal]

Albert
Thanks for the info. I am on my way to the book store to find a vba
for office book.
I looked at your wordmerge22.zip file - very slick. But I can't get to
the code to look at it. I noticed that your commandbar loaded right
up, but it did not disable the commandbars that I already had loaded.

interesting, your command bars should not have shown. Perhaps you have
created a few of your own, and un-checked the allow hiding, or custom
options.

As far as I know, as a general rule, that sample should load and NOT show
anything else (ie: no other tools bars/menus bars should show)....

However, to get into the application, you just hold down the shift key
during startup of the application. This will "ignore" all the tools startup
options. (you will get VERY used to using the shift key stuff when you start
getting your application ready for your users. You likely also will "hide"
the ms-access interface. I believe if you created a mde, then those other
menus of yours likely would not even show.).