[AccessD] Word constant list for VBA

Wow. I had no idea there were that many. Sheesh!

On Thu, Feb 21, 2008 at 4:56 PM, Heenan, Lambert <Lambert.Heenan at aig.com>
wrote:

> How about here?
>
> http://msdn2.microsoft.com/en-us/library/aa211923(office.11).aspx<http://msdn2.microsoft.com/en-us/library/aa211923%28office.11%29.aspx>
>
> And
> http://msdn2.microsoft.com/en-us/library/aa172255(office.11).aspx<http://msdn2.microsoft.com/en-us/library/aa172255%28office.11%29.aspx>
>
> Etc.
>
> Lambert
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Thursday, February 21, 2008 2:34 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Word constant list for VBA
>
>
> 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
>
> --
> 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
>