Heenan, Lambert
Lambert.Heenan at AIG.com
Thu Feb 21 15:56:34 CST 2008
How about here? http://msdn2.microsoft.com/en-us/library/aa211923(office.11).aspx And http://msdn2.microsoft.com/en-us/library/aa172255(office.11).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