使用 VBA 用户窗体和宏保存 Word 文件
我创建了一个带有一些函数的 VBA 用户窗体,并使用宏运行它,并将其保存为 .docm 文件。但问题是当我尝试从另一台计算机运行该 docm 文件时,没有任何效果。后来当我检查VBA代码时,我发现我的userForm1不在那里。我不知道那里发生了什么事。如何解决这个问题,以便我可以在另一台计算机上运行我的 VBA 表单?
I created a VBA userform with some functions and running it with a macro and saved it as a .docm file. But the problem is when I am trying to run that docm file from another computer, nothing is working. And later when I checked the VBA code, I saw my userForm1 was not there. I have no idea what is going on there. How to solve this issue, so that I can run my VBA form into another computer ?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
虽然我得到了解决方案。但我不认为这就是终极的。解决方案是通过单击“宏菜单”>“组织器”>“将所有表单和宏传输到该 dotm 文件”>“保存 dotm 文件”,将这些表单和宏加载到 dotm 文件中。当您需要将其恢复到另一台计算机时,只需反转该过程并将其存储到 Normal.dotm 文件中即可。
Though I got a solution. But I dont think this is ultimate one. Solution is load those forms and macro into a dotm file by clicking Macros Menu>Organizer>Transfers all forms and macros into that dotm file >save the dotm file. And when you need to restore it into another computer, just reverse the process and store those into the Normal.dotm file.