[AccessD] Issues with running applications in 64 bit version of Office

Stuart McLachlan stuart at lexacorp.com.pg
Sun Jan 29 18:11:43 CST 2012


It is poorly explained in the stackoverflow link.   A better reference is:

http://msdn.microsoft.com/en-us/library/ee691831%28loband%29.aspx#odc_office2010_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
> 




More information about the AccessD mailing list