Question

office2013，vba运行出错。

运行时数据处理错误，调试逐行运行却没有问题，用老版本excel运行也没问题，有人遇到过这个情况吗，怎么解决？

Answer 1

移动版（rt）取消了vba，桌面电脑仍然存在
如果你安装了office2013，而没有找到vba，那是因为微软把他藏起来了，并且默认禁用宏
打开方法：
文件
-->
选项
-->
自定义功能区
-->
右侧
开发工具
，前面的勾打上
-->
确定！

Answer 2

旧版本的VBA裏面要改一些代码，才能在2013裏面用，如我的代码：
Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long
Private Declare Function GetWindowLong Lib "user32" Alias "GetWindowLongA" (ByVal hWnd As Long, ByVal nIndex As Long) As Long
Private Declare Function SetWindowLong Lib "user32" Alias "SetWindowLongA" (ByVal hWnd As Long, ByVal nIndex As Long, ByVal dwNewLong As Long) As Long
要改成：
Private Declare PtrSafe Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long
Private Declare PtrSafe Function GetWindowLong Lib "user32" Alias "GetWindowLongA" (ByVal Hwnd As Long, ByVal nIndex As Long) As Long
Private Declare PtrSafe Function SetWindowLong Lib "user32" Alias "SetWindowLongA" (ByVal Hwnd As Long, ByVal nIndex As Long, ByVal dwNewLong As Long) As Long
好像多了“PtrSafe”字。

Answer 3

把具体的实例发来看看

Answer 4

看一下具体的代码，说明错误在什么地方