Automatic VBA Add-in In Excel

[kkzin]

Hi, there

I have created my VBA add-in.

When i want use it, I go Tools\Add-Ins\
and in Add-Ins dialog , I check my add-In.

And next every time I open Excel,
I don't need to do above steps to use my add-in.

So if I want to use my own add-in,
I imports it manually for the very first time.

How can I use my add-in without importing it manually.
Is there any way?

Thanks you,

kkzin

[zaza]

Put it in the Excel addins folder for the particular user? In Application Data, I believe...

[dmaruca]

From the help file:


Global templates and add-ins
Checked items are currently loaded Lists available templates.

Add Click to open the Add Template dialog box. Use this dialog box to load a template. To automatically load a template or add-in when you start Word, place the template or add-in in the Microsoft Word Startup folder.

Remove Removes the selected template or add-in from the list. To unload an item from Word but leave it in the list, clear its check box. Remove is unavailable for items located in the Word Startup folder.

Who knows where the startup folder is? I don't.

[zaza]

It's in Application Data...(and a few subfolders below that)