[AccessD] Word constant list for VBA

jwcolby jwcolby at colbyconsulting.com
Thu Feb 21 13:33:40 CST 2008


Well, it is indeed in the help but you have to be in whatever application
you are working with.  So for example if you are programming in VBA in
Access, these constants for WORD do not show up.  Even if they did, I can't
just use the constant because they are part of the library for that object
lib.  I do not reference Word directly because of version differences on the
user's workstations.  So I do early binding when I do development, but late
binding when I deliver the application.  

As a result, the constants can "just be used" if I am using early binding
but break when I switch to late binding.

Therefore... I need a module of these things and there are THOUSANDS of them
for each object library, for example word has thousands of constants, Excel
has thousands etc.  

I though perhaps someone could point me to a Word constant module where all
these things were defined and I could just drop that module into my code.  I
spend lots of time today just looking up the specific values for the handful
of specific constants that I needed.


John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert
Sent: Thursday, February 21, 2008 1:45 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Word constant list for VBA

OMG!!!! I find it hard to believe, and even harder to promote, but this
information is in...

...
...
...
...

... the On-Line Help!!!!!! 

Open any module and hit the F1 key. When good old (?) OLH appears click the
Contents tab and right there at the very top is a section entitled
"Constants"

HTH

Lambert :-)

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Thursday, February 21, 2008 1:29 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Word constant list for VBA


Does anyone have a good reference or better yet a module of word constants
for use in VBA?

I need things like 

const wdSaveChanges = SomeValue
const wdPromptToSaveChanges = someothervalue etc

John W. Colby
Colby Consulting
www.ColbyConsulting.com 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list