vba Excel 2003 - 如何构建我自己的 XLA?
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/2594983/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Excel 2003 - How to build my own XLA?
提问by Justin
How can you make the .xla file if you want to create your own xla? I have the code, classes, shapes, etc....what is the process to making an xla file to point to? I know that I have to put it in my program files folder, and then go through the steps to adding an "add-in" in xls...but i mean actually saving an xla file to point to....
如果要创建自己的 xla,如何制作 .xla 文件?我有代码、类、形状等……制作 xla 文件指向的过程是什么?我知道我必须将它放在我的程序文件文件夹中,然后执行在 xls 中添加“加载项”的步骤……但我的意思是实际上保存了一个 xla 文件以指向……
can i simply write all this in xls and then save it as file type xla?? because i have tried to do that but I get an error that it is not a valid add in when I am in a spreadsheet trying to point to it?
我可以简单地将所有这些都写在 xls 中,然后将其保存为文件类型 xla 吗??因为我曾尝试这样做,但是当我在电子表格中试图指向它时,我收到一个错误,表明它不是有效的添加项?
thanks!
谢谢!
回答by James Campbell
This should help:
这应该有帮助:
Create an .XLA file
创建 .XLA 文件
http://www.vbaexpress.com/forum/archive/index.php/t-496.html
http://www.vbaexpress.com/forum/archive/index.php/t-496.html
http://www.xtremevbtalk.com/archive/index.php/t-62362.html
http://www.xtremevbtalk.com/archive/index.php/t-62362.html
http://www.ehow.com/how_5066365_create-excel-xla-addin.html
http://www.ehow.com/how_5066365_create-excel-xla-addin.html
Creating An XLA Add-In For Excel
为 Excel 创建 XLA 加载项
http://www.cpearson.com/excel/CreateAddIn.aspx
http://www.cpearson.com/excel/CreateAddIn.aspx
Microsoft Excel VBA Macros. How to Create an Excel Add-in For Them
Microsoft Excel VBA 宏。如何为他们创建 Excel 插件
http://www.ozgrid.com/VBA/excel-add-in-create.htm
http://www.ozgrid.com/VBA/excel-add-in-create.htm
Excel VBA - install an Excel Add-in (XLA or XLL)
Excel VBA - 安装 Excel 插件(XLA 或 XLL)
http://vbadud.blogspot.com/2007/06/excel-vba-install-excel-add-in-xla-or.html
http://vbadud.blogspot.com/2007/06/excel-vba-install-excel-add-in-xla-or.html
If you are still having issues let me know...
如果您仍然遇到问题,请告诉我...