如何查找库或打开VB编辑器以加速代码 [英] How to find a Library OR open VB Editor to speed up code

问题描述

我不明白为什么当VBE打开时Excel VBA代码的运行速度要快得多。

我在网站上发现了一些人们认为会有所帮助的代码，但我不知道我需要引用哪个库才能使其正常工作。

任何人都可以帮助我吗？ 或者任何人都可以提出另一种/更好的方法来克服这个问题吗？

Sub VBAEditor（）

Dim oCtrlDef作为ControlDefinition

Set oCtrlDef =

ThisApplication.CommandManager.ControlDefinitions（" AppVBAEditorCmd"）

oCtrlDef.Execute

End Sub

谢谢。

解决方案

< blockquote>

如果VBE关闭，通常代码运行得更快，虽然它取决于代码。

您的代码段似乎与AutoCad有关，为什么您认为这有助于您的Excel VBA，或者您是否尝试从Excel自动执行AutoCad。

在VBE打开的情况下，提供有关您认为运行速度更快的代码的信息。

Hi,

I don't understand why Excel VBA code runs much faster when the VBE is is open.

I found some code on a website that people say will help but I don't know which library I need to reference to make it work.

Can anyone help me please?  OR can anyone suggest another/better way of getting over this problem?

Sub VBAEditor()
Dim oCtrlDef As ControlDefinition
Set oCtrlDef =
ThisApplication.CommandManager.ControlDefinitions(​"AppVBAEditorCmd")
oCtrlDef.Execute
End Sub

Thank you.

解决方案

If anything normally code will run faster when the VBE is closed though it depends on the code.

Your snippet appears to be related to AutoCad, why do you think that would help your Excel VBA or are you trying to automate AutoCad from Excel.

Give information about the code you think runs much faster with the VBE open.

这篇关于如何查找库或打开VB编辑器以加速代码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！