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

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-11 11:31:11  来源:igfitidea点击:

Excel 2003 - How to build my own XLA?

excelvbaexcel-vbaexcel-2003xla

提问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