重新使用Excel VBA而不导入它 [英] Reuse Excel VBA without importing it

问题描述

我通过重新编写我的动作创建了一个新的宏。它用于从Excel文件中删除列。如果我必须在我从网页上下载的excel文件上运行这个宏，我必须以视觉基础的形式导入宏，然后运行它。

我可以以某种方式使此宏可用于excel，以便我可以将其运行到我从网站下载的所有excel文件，而无需在视觉基础中导入宏？

解决方案

您可以将宏保存到您的个人工作簿： http://excelhints.com/2010/11/29/how-to-use-your-personal-macro-工作簿/

以此方式保存的宏可用于其他工作簿。

I created a new macro by recoding my actions. It is used to delete columns from an excel file. If I have to run this macro on excel file that I download from the web, I have to import the macro in visual basic and then run it.

Can I somehow make this macro available to excel so I can run it to all the excel files that I download from a site, without importing the macro in visual basic first?

解决方案

You can save macros to your personal workbook: http://excelhints.com/2010/11/29/how-to-use-your-personal-macro-workbook/

Macros saved in this way are available to other workbooks.

这篇关于重新使用Excel VBA而不导入它的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！