Addins

I think this will work if you place you addin in the XLSart folder, seach for it if you cant find it. I believ if it is placed in there then it is referenced and accessed everytime you open Excel.

After creating your add-in as an excel workbook, you then save in as an add-in file.
File > Save As > then select addin (xla) as the file type. You can save it in any folder but its better to save it in the Add-ins folder (somewhere in Program filesoffice.. please search).

Then you register your add-in with excel as follows:
Tools > Add-Ins > then check your add in in the list. If you don't see it, you can browse for it and locate it.

After registering your addin, all functions and procedures will be available to excel just as if they were part of the current file.

No I mean I have the code for a program that I have created and I wanted to know if i had to use application.run or whether I could just link the files together.

Brett

On 2002-08-22 02:40, brettvba wrote:
No I mean I have the code for a program that I have created and I wanted to know if i had to use application.run or whether I could just link the files together.

Brett

Click to expand...

Brett, I guess the 1st Q is what does your addin do. Addins just add extra functionality to your Application. What are you intending this Addin to do ?
Typically, an addin will provide access to it's extended functions via a UI eg commandbar or formula function.

OK, well I have striped the code out of an application that I have made and made the code into an addin, as I have found since I want to share the workbook that some code works fine off share mode and doesn't work at all on share mode, right about now Im wishing I had access to a more sutiable program for my task, I was even continplating using a web page locally over our network, ok ok so I have firstly started with the addin to see if that changes anything it also means I can change the code without having to unshare the book all the time.

Brett