Doug Murphy
dw-murphy at cox.net
Sun Jan 29 18:45:34 CST 2012
Great. Thanks for the reference. Doug -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Sunday, January 29, 2012 4:12 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Issues with running applications in 64 bit version of Office It is poorly explained in the stackoverflow link. A better reference is: http://msdn.microsoft.com/en-us/library/ee691831%28loband%29.aspx#odc_office 2010_Co mpatibility32bit64bit_IntroducingVBA7CodeBase <quote>VBA 7 is a new code base, replacing the earlier version of VBA. VBA 7 exists for both the 32-bit and 64-bit versions of Office 2010. It provides two conditional compilation constants: VBA7 and Win64. The VBA7 constant helps ensure the backward compatibility of your code by testing whether your application is using VBA 7 or the previous version of VBA. The Win64 constant is used to test whether code is running as 32-bit or as 64-bit. Both of these compilation constants are demonstrated later in this article.</quote> -- Stuart On 29 Jan 2012 at 23:51, Darryl Collins wrote: > I don't disagree, but I think #VBA7 is the only build in constant available in VBA > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms > Sent: Monday, 30 January 2012 10:13 AM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] Issues with running applications in 64 bit version of Office > > OMIGOSH - that is a horrible convention ! It implies VBA7 = Office 2010 64 bit under Win64... > And Win64 implies Windows 64 bit with Office 32 bit. > Am I right ? > > Better directive naming: VBA64WIN64, VBAWIN64 > > > > > <<http://stackoverflow.com/questions/3072356/what-are-the-differences- > > between-vba-6-0-and-vba-7-0>> > > > -- > 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