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

User avatar
ChrisGreaves
PlutoniumLounger
Posts: 15635
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.
There's nothing heavier than an empty water bottle

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