[AccessD] Word constant list for VBA

Wow!  Now that is service.

Thanks Stuart. 


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 Stuart McLachlan
Sent: Thursday, February 21, 2008 6:08 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Word constant list for VBA

I've got a little "Com Browser" utility that comes with PowerBasic 

"The PowerBASIC COM Browser is an application that exposes the Interfaces,
Methods and Properties of COM Objects, as described by type-library files.
The PowerBASIC COM Browser serves a dual purpose - to export an Interface
Structure of a COM Object for early-binding purposes in your PowerBASIC
code, and to provide syntax reference and context-help on the Interface
members exposed by a COM Object."

I've just run it on my "Microsoft Word 10.0 Object Library 8.2" and
extracted the 2674 enumerations to a text file - only a few seconds work.
It took another 30 seconds with a good text editor using Find/Replace to
turn the whole file into a set of Const Public declarations suitable for use
in VBA.

I've uploaded it to http://www.lexacorp.com.pg/Misc/WordEnums.zip

Enjoy,
Stuart


On 21 Feb 2008 at 13:28, jwcolby wrote:

> 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