Darryl Collins
darryl at whittleconsulting.com.au
Mon Jan 30 16:25:05 CST 2012
Thanks Jim, I didn't explain that too well. I did know there were other constants, for some reason I was thinking of one for XL2007 and XL2010 vs Xl2003, which isn't built in AFAIK. Should pay more attention! Been really busy at work this week. Cheers darryl -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Monday, 30 January 2012 11:58 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Issues with running applications in 64 bit version ofOffice No, there are other constants. Check the EE thread I posted. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins Sent: Sunday, January 29, 2012 06:52 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Issues with running applications in 64 bit version ofOffice 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