摘要
微软在Office 2010中引入了VBA 7.0,并增加了64位版本,扩展了数据类型,改变了部分Windows API的声明格式,因此造成了VBA代码的不兼容。为了在64位环境中运行原有的VBA程序,需要对旧代码中涉及API函数、指针、句柄的声明及调用语句进行完善,包括添加Ptr Safe等关键字,修改相关变量为Long Ptr、Long Long类型等,并通过条件编译语句和编译常量Vba7、Win64,来确保程序在32位和64位环境中的兼容性。经过这些修改,就可以保证代码在各版本的VBA中能够正确地运行。
Microsoft introduced VBA 7.0 in Office 2010,adding a 64-bit version,expanding the data type,and changing some of the Windows API declarations.These changes caused incompatible VBA code issues.In order to run legacy VBA programs in a 64-bit environment,requires refinement of the declarations and call statements in older code involving API functions,pointers,and handles,including adding keywords such as PtrSafe,modifying the relevant variables LongPtr,LongLong and so on.By conditional compilation statements and compiler constants Vba7,Win64,ensures the program compatibility in 32-bit and 64-bit environment.After the above changes,you can ensure that the code in each version of VBA to run correctly.
作者
韩建彬
Han Jianbin(PAP Command College,Tianjin 300250,China)
出处
《计算机时代》
2018年第4期4-6,共3页
Computer Era
关键词
VBA
代码兼容性
64位
条件编译
VBA
code compatibility
64-bit
conditional compilation
