add-ins

Hello everyone! o/ As everyone is used to the 'drill-through' feature upon the common pivot table, where you double click a calculated cell (not column label, nor row label) and then its relative data pops out into another spreadsheet. And everyone know it's an awesome feature. BUT, in...

I want to add my excel file with macro to add-ins custom toolbar. my excel file (myfile.xlsm) : GOAL/problem: In short basically,my goal is opening the "myfile.xlsm" through add-ins custom toolbar. Instead of opening myfile.xlsm directly I want it to be "hidden" in the add-ins folder. I...

Hello MrExcel forum members, I am trying to enable and disable Excel's Add-Ins using VBA. I originally had code that searched through the Excel file and grabbed the names of the Add-Ins from cells in the spreadsheet and uninstalled them. That wasn't working, so I tried using a simpler method...

I've seen some similar problems described by others before but no real solution. And I'm sure there is one. I have a .XLA-add in configured to be loaded when I open up Excel. It works fine when I open documents or Excel it self. However, when my BI-system programmatically creates and opens an...

I have a macro-enabled workbook with several modules and class modules full of code. Two modules in particular are meant as UI entry points: PublicMacros and PublicFunctions. These are the only two modules with no Option Private Module statement: PublicMacros has nothing but Public Subs with...

I have noticed a menu choice "Actions" for add-ins in Excel 2013, and have been unable to learn more about what sort of add-in this is. Could someone point me towards a detailed description?

<tbody> I have an excel sheet where column A has a list of product codes. I also have a folder with pictures of each product and file name of the pictures are the product code. I would like to place the picture of each product in column B beside their respective codes. If possible, I would...

Hi, I am facing one problem with one Excel file. While opening it displays a message that "This workbook contains macros.....". However, I have checked all the macros, VBA modules etc, but hardly find any macros or VBA. It seems that the creator has inserted some macro in a hidden format. I am...

I have been working on this problem for several days almost non-stop. Is it possible to have a spreadsheet where all the VBA code is contained in an Add-In (.xlam)? The code contains both Functions and Subroutines. The Subroutines are invoked using command buttons on the original spreadsheet...

I have an excel add-in which is a ribbon which houses a great deal of financial tools that I use on a regular basis so I don't have to hunt around excel for things I use regularly. The add-in has always loaded automatically whenever I opened excel - whether I opened excel by creating a new blank...

I have recently gone 64bit and really miss ASAP utilities as an add-in, while recognising the huge benefits that going 64bit has made to my work life. Is there a list anywhere of 64 bit add-ins? Is there anything that even approaches ASAP in scope? Actually 32bit ASAP is so good, I am...

I just got a new laptop with windows 7 and when I click the file open icon in excel 2010, the entire spreadsheet locks up. It sounds like this could be an add-on issue. The only add-on I have is pdf filemaker. Once I am locked up, I have to kill excel through the task manager. Has anyone...

I use Access 2010, but many clients still have 2003, so I have to deal with 2003-format files all the way. I've developed MyTools.MDB with nothing but macros and modules containing various tools like exporting all objects to text files. I want to make it an add-in so I can open any MDB or...

I am/ was using E- signal Q link 2.0 which was running on DDE, and I deleted & upgraded to Esignal Q link 3.0 which runs on an RTD. The uninstall, re-install process was messy and the rep that assisted me even had me delete some Q link files from the registry. After the Q link re-install I...

I made a Excel 2003 with macros and Add-Ins, .....Menus etc. Now I create a Ribbon tab in Excel 2010. when I put the tab Add-ins and click on the tab do not show the worksheet that supposed to be showed and do not show the UserForm this is the code for Ribbon to call the Userform Precios Option...

Hi All, Thanks in advance. Excel 2007 I'm looking for a macro to run the same Add-In on various different workbooks. Add-In name is "HRwsBTH" I have about 20+ workbooks that I need to open and manually refresh my Add-In and it's very time consuming. So what I would like to achieve with the...

What I am trying to do: - Create an add-in that does a simple extended cost calculation = (unit_cost) x (units_per_pack) x (packs_per_carton) - I want the calculation to be based on the column header (always in row 1) rather than column A, B, or C because in different spreadsheets the columns...

hello guys, does anybody know/create any hijri calendar for excel 2007 add-ins?thanks.

<colgroup><col><col><col><col span="3"><col span="2"><col><col span="3"><col><col><col><col><col><col><col><col><col></colgroup><tbody> Ticker Company Current Price 12 Month Risk/Reward Curr Price/ 52Wk High Curr Price/ 52Wk Low % Ch Price Year-to-Date Div Yield Anl EPS before NRI Current Fiscal...

The Add-in tab is not appearing on my toolbar, even though I have activated multiple Add-ins. Any thoughts anyone??