add-in

I am trying to get the MrExcel HTML Maker add-in to work on my Excel 2007 system. I've downloaded the install ZIP file, unzipped it, copied it to the add-in folder, and added it to the add-in list. If I click File | Excel Options | Add-Ins, I see it listed at the top under "Active Application...

Hi Guys, I have an Add-In and various procedures look up various directories to pull data and other stuff. Whilst this works fine, if I move my Add-In to another network with different Drive names then I have to go and amend the code to fit with the new Drive conventions. Fine if it is me but...

I have some workbooks that friends or family members have asked for. Most of them make use of UDFs that are in my personal add-in module. I don't want to give them the entire add-in module for several reasons. What's the best way to make these workbooks transportable? If I copy the UDFs to a...

I have a personal add-in module that I have used for years. It is called zzz add-ins.xlam and is stored, along with a couple of other add-in modules, here: C:\Documents and Settings\Administrator\Application Data\Microsoft\AddIns It contains dozens of UDFs that I have written over the years and...

Hi, I created the following xml in my .xlam add-in file to load a new tab and menu which works but when I click the Icon, I get the mentioned error . I do not have a separate file open with a same named module which I read can cause this problem. The generate call back and validate identify...

Do any of you know of an Excel function or add-in that would convert currency with custom rates? I was going to make an add-in that would do the simple conversions for me but before I jump into that I was wondering if there was something already out there that accomplishes this. In case you...

I created an Excel Add-in but it won't display under the Add-in tabs. I tried with Excel 2013 and Excel 2016. The add-in is saved in the Microsoft folder for addins (AppData>Roaming, etc.)Things I've tried....Excel Options > Add-ins > Excel Add-Ins > Go .... Select it.Excel Options > Add-ins >...

Hi all, Just wanted to confirm is there any way we can create Add-in for Outlook( it includes Outlook Item_send). I wanted to trigger Event when ever user click to send mail, I know how the process works I can write manually (by pressing ALT+F11). But I have more than 100 user, I can't write...

Hi, I see that there are numerous free programs that can remove VBA module passwords. I want to distribute a solution we have developed to a client, but as an Add-In, and want to know how the security differs between the Add-In and a normal macro enabled file (with the VBA code password...

Hi All I'm just exploring using Add-In's to slowly build up a Function Library. Do please tell me if this is not the right way to go but the idea I have is to save the macro enabled workbook as an Add-In when I close the workbook. I have recorded a macro and notice that whilst code is...

Hello all, I have a com add-in and I am wanting to execute some of the functions with a macro. is this possible and if so, how? Thank you in advance for your time!!!

Hey! Just created a macro. When I run it from the workbook where I created it, it runs just fine (if I copy the base from another excel). But after exporting it as an Add-in and trying to run it with a keyboard combination it gives me the error: "That name is already taken. Try a different...

Is this plot realizable in Excel without any additional software?

Good Morning accomplished VBA peers. I'm running into a problem. I need to add-in an additional IF parameter and it's complicated. It touches on parts of VBA that I am not comfortable with and frankly, I don't know how to begin. This macro was essentially written by this board anyhow...

Have Excel 365 Pro Plus V 1705 Build 8201.2213. An error message popped up when saving that I had some error in a spreadsheet (with many links and formulas). Found reference to Inquire and tried to find add in (Alt - T). Did not see "Inquire.InteractiveDiagnosticsAddIn". How to proceed to...

Hi & Happy New Year 2018 Am i being too simplistic? Trying to check if a COM Add-In "BERTRibbon.Connect" is installed and if not ignore a line of code that then turns it off If Application.Addins("BERTRibbon.Connect").Installed = False Then GoTo jmp This doesn't work, and I guess because...

If I want to send a friend a workbook that uses UDFs in my personal add-in module, but I don't want to sent the entire add-in module, do I just copy the UDFs it needs to a code module in that workbook? Is that code module the one named "ThisWorkbook" or do I need to create one? Thanks

I was working on a spreadsheet (Excel 97) and every time I would type into a cell in Column A, it would automatically insert a new row above the given cell. This was a good thing! It would keep the amount of empty rows above my typing the same. I guess, at some point, I deleted a macro or...

I have just installed the Dropbox add-in for Office 2016 (365). This add-in allows the user to see the Dropbox icon/ folder in the browse (left-hand) menu of the File -> Save option from any Office application. We have a BeforeSave event firing on an Excel application. However, if the user...

Using Excel 2013 & 2016. I just created an .xlam add-in for the first time today. A UDF user defined function was added to a blank workbook and saved as .xlam file in the Microsoft Add-Ins folder. If you have many macros that you use globally, that is you use for/on any workbook, is it better...