addin

Hi I have an excel add-which is running great, however, I wish to start adding my UDFs to it. I have the code to register my UDFs but I was wondering if there is a way of automatically running the UDF registration macro when the add-in is loaded? Many thanks!

Hii, i want to know how to create and undo addin which will undo the actions performed by any other addin plss help...:):)

So this is a lengthier question. I don't understand what is going on here so I wanted to ask you guys what is going on. So I wrote an add-in that would allow me to "reset" a workbook that I had. What it does is take a workbook and goes through each page to select cell A1, remove freeze panes...

Hi All, I have created a Sub which does a few things: 1) Ask for a string 2) Queries a db with said string 3) Creates a new sheet on active workbook with the name of said string 4) Past the recordset in the new sheet If I run the Macro on its own it does everything fine. However i have now...

I have created an Excel Addin in VBA which reads a cell value and save in SQL database. In Addin, I have created a VBA function SubmitCellValue in a module which can be called as =SUBMITCELLVALUE(A7) in excel and save value from A7 in database. Above part is working fine, Now I want to add a...

Hi, I've created an Addin for a macro I use for reporting purpose. Add in selected from Add in window but isn't showing in Add in BAR. Please let me know the email ID, I can forward the add in file to take a look. \\AppData\Roaming\Microsoft\Addins\GPR.xla

hello everyone, i have a huge problem and i hope you can help. i'm using excel 2013 and i bulit a very big excel that has about 20 pivot tables. when i built them i used the "add this data to Data Model" option and now i send this file to a client for him to use. the client is using excel...

I manage to display the chm help file to an User-Defined Function by clicking on the "Help on this function" in Insert Function dialog box. This was possible only when the my file is xlsm. After I saved the xlsm file as an xlam file (an addin) and installed the addin. The help file can be...

<article>Hi Everyone, It's been a long time since I visited this forum. anyway greetings to all. I come across the idea of adding security to excel vba code particularly the addins in which we all know that it can still be easily cracked. Anyhow I don't know the codes and how to make it...

Hello, I have a .xla addin I've made to control user access to a particular set of documents shared on a network drive. I want to make the .xla check the network drive for a newer version of itself each time excel is opened and if it finds a newer version either copy it over itself, or copy the...

I've done this before, but cannot remember how I did it and Google is not my friend this morning. I've created my custom Add In and can select it through the Add In menu, no problem. I run into an issue when I try to assign it to a ribbon item in that I cannot find it anywhere. All of my...

Morning, I need help using VBA to load and install my macro as an AddIn. I created a macro to autocorrect room number problems that we've been having in excel because of the way excel interprets the room numbers into Scientific Notation and Dates (ei: 9E23 becomes 9E+23 or...

I have an addin that uses SheetSelectionChange event to highlight the entire row and column in a sheet when I click on a cell. I would like the option to turn the highlighting on/off by selecting a checkbox. I added a checkbox by customizing the ribbon, and I have code that passes the value of...

Hi, We currently have users on both versions of excel (2010 and 2013). The 2013 user is using an addin that converts currency to text which is pasted below. We believe there is a compatibility issue or a security setting that i'm not seeing to make it work 100% on the 2013 user. here's what...

Hi, I am new in here and I would really like to find out if there would be interest from the community for our latest Excel Addin that uses an implementation of Decision Trees for time series forecasting.This is a tested algorithm that has been developed over a number of years and used...

Hi Thanks in advance for your help I am using solver to build a feed formulation software where I can set min and max variable constraints and referencing that to the solver addin using code to least cost feed rations. My problem comes in when I try to use more then 300 or so constraints. It...

:confused: I have four macros that I need to make available to other users. I opened a blank spreadsheet that has the macros and saved it as an xla file called "Jeff's Macros". I stored it in a common folder. I went to a coworker's station and opened Excel and checked Jeff's Macro's under...

Hey everyone, I have a spreadsheet that needs to use solver, I have the following code to install the solver add-in when required: Application.AddIns("Solver Add-in").Installed = True All is working fine on the computer used to develop the spreadsheet, however when I tried it out on a few...

Hi All, I am very much still a rookie here and in developing in general. I am running into a bit of an issue with a Add-in I am designing. Basically, I am trying to write an add-in that does 2 things, 1. Allows a user to create a certain report based on a choice of possible reports via a...

hello, In an addin, I need to handle 2 workbooks, unfortunately their names vary, so I don't know how to refer to them so that it would work. 1) I open the first workbook and save it under the variable WB1 (workbook1) 2) then I open the second workbook using the code and save it under...