![]() ![]() Helpfully Microsoft has added a new data type in VBA 7 (Office 2010) called a LongPtr. Unfortunately previous versions of Office (2007 backwards) do not have a data type that holds a 64-bit value, and in 2010 32-bit, you don’t want one! Fortunately VBA uses VERY few pointers 95% of them are involved in API or DLL calls. ![]() The main difference between 32 and 64-bit Microsoft Office (VBA wise) is that any pointers now need to be 64-bit rather than 32. There are actually very few issues with moving code from 32-bit Office to 64-bit Office, but a couple of them are significant. If you don’t care about reasons or explanations, skip to the summary to see how to avoid or fix the issues. It’s the first time this has been an issue, and I thought I’d detail some of the effects. In the last week I’ve had a client upgrade to 64-bit Microsoft Office and it has caused some havoc with parts of my VBA.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |