Microsoft made several changes to VBA in Office 2010 ...

User avatar
ChrisGreaves
PlutoniumLounger
Posts: 17030
Joined: 24 Jan 2010, 23:23
Location: brings.slot.perky

Microsoft made several changes to VBA in Office 2010 ...

Post by ChrisGreaves »

FYI:
Microsoft made several changes to VBA in Office 2010
Discusses the vbLongLong, LongPtr, PtrSafe and VBA7.
It is better to Aim High and Fail than to aim low and succeed.

User avatar
HansV
Administrator
Posts: 80381
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Microsoft made several changes to VBA in Office 2010 ...

Post by HansV »

These changes only affect code that uses Windows API functions, and if you either use the 64-bit version of Office 2010 or want the code to run on 32-bit and 64-bit Office 2010.

See for example Transfer from 32 bit to 64 bit machine and 32/64-bit compatible version of Outlook Attachment Manager.

Jan Karel Pieterse has written an article about the changes, with useful links: Declaring API functions in 64 bit Office.
Best wishes,
Hans