addin

Hi there Using MS Office 2010. Windows 7 platform. I would like to create a report (eventually automated) if possible. User to nominate date range. It will be only ever for a specified Outlook folder. Data only to be returned if "Authorised" is text within the subject line. The report is...

Hi I have downloaded Html Jeanie and have checked that it is an 'Active Application Add-in' however I cannot for the life of me see it in my ribbon or work out where it is. The only other addin I have tha tis active is Adobe pdf Maker which has its own ribbon I have search the net and...

Hi, I have placed an Add-in in a network drive and installed in each workstation all using Excel 2007 without copying it to the local Addin folder in order for everyone to access the same Addin as read-only except myself who is allowed to make changes and save. I have set-up the Workbook_Open...

Hi all, I am new to excel programming. I want to know can I add addin(mecros like thing create using VBA) to ribbon of EXCEL 2010.I did not want run like mecros.That addin should load with excel. Pls help me.Can I do this using VBA.If not what is the method?

I'm trying to make my VBA addins simpler to install for my co-workers so that they can install and update them to their computer with basically just the click of a button. I have been able to get the code to work fine for my computer and another co-worker's computer. But when I tried to...

I have written a very nice little excel add-in which creates a report of all the errors on my workbook and then hyperlinks to them. I have assigned a hotkey to the macro and then saved the workbook as an .xla. All works fine. However, I want to add comments in the little comment box in the...

Morning, I ran an excel add in I found called Jr Picker, since loading it my forms are locking up. I have tried to delete it from my menu bar; however, it keeps coming back. I can not find it in my add in list from the Excel Options to delete it. Does anyone know how I can find this to get rid...

I have an Excel Addin that I deploy as a read-only addin on a server share. I instruct my co-workers to add the Add-In as they would any other Add-In, but I tell the to answer NO to the Windows question "Copy 'AddinName' to the Addins folder for John Doe?". That way, everyone will be working...

I try to install an AddIn. When I use the code below it copies the addin-file to "C:\Documents and Settings\admin\Application Data\Microsoft\AddIns" before it will work. Why do I have to copy it? I want to install it and keep it where I've already placed it. If i use...

Hi all, I moved all my macros to an addin that two separate workbooks use. I set up the references fine and didn't move the addin to the standard folder when asked as other people on the network will want to use it when this goes live. It all worked fine, but intermittently the workbooks...

Any help would be appreciated...I am using Excel 2007. My objective is to load an add-in file when you run Excel as an OLE Automation object, without having to load the add-in manually. However, the macro is not loading solver automatically: Sub LoadAddIn() Dim xl As Object '...

I have an excel 2003 workbook that is crashing in excel 2010. The workbook is crashing due to a reference to funcres created in vba. I do have the 'Analysis ToolPak' addin checked which is tied to funcres. Yet, I can't find funcres when I go to References under Tools when I'm in the Visual...

I'm trying to run some excel macros through VBScript. The code also uses Bloomberg addin. Now, I know that VBScript by default switches addins off so in the script I have lines that add Bloomberg addin. Problem is - while debugging, I get 'NAME' errors in cells that use Bloomberg functions...

First off, does anyone know in which Bloomberg Addin is the BDH formula found? Secondly, if possible, I've had a hunt on the internet to no avail, but does anyone know the passwords to the addins? The first point is the most important, the second is just a bonus :) thanks in advance.

Hi everyone, I have a user with a budget add in for excel, but when she goes to upload the budget, she receives the error message above. The add in itself is quite old and was written for Excel 2003, but she is using 2007. There are other users who do not receive this error but also have...

OK, I have 2 problems. 1st - When I close my workbook named Personal I want to uninstall/close an addin that is installed/opened when I open my Personal book, the addin is named Testing1.xla 2nd - I want to also remove buttons that are created by the addins on the menubar, the buttons have a...

I recently downloaded Morefunc for excel and have been playing around with some of the functions. Truth be told I downloaded morefunc for its EVAL function which, from what I understand can accomplish the following: In A1:A3 (for instance) a1 = 3 a2 = + a3 = 5 =evaluate(a1&a2&a3) And the...

Hi, Is this code permissible in a custom add-in (XLA)? For Each rngCell In Worksheets(gs_sheet).Cells(gl_last_row, gl_last_col) If Trim(rngCell.Value) = "" Then rngCell.Value = 0 "< ----- error in XLA here End If Next rngCell It works fine when executed as...

Hi, We are developing an Excel VSTO document-level addin. One of the requirements of the addin is to generate a large number of very long named ranges. This is done by calling a VBA macro from the VSTO addin to create the ranges. The VSTO addin is linked to the workbook through two custom...

I've been searching all over and have not been able to find this, so I'm hoping soneone else knows how to do this. I have a macro that loads itself to Excel 2007's Addin tab on the ribbon via: Application.CommandBars("Worksheet Menu Bar")But I really want to have it create it's own tab on the...