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

User avatar
ChrisGreaves
PlutoniumLounger
Posts: 16172
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.
The brain is a three-pound mass you can hold in your hand that can conceive of a universe a hundred billion light-years across (Marian C. Diamond)

User avatar
HansV
Administrator
Posts: 79365
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