add-ins

  1. L

    Add-ins MenuBar Duplicates in Drop Down when opening multiple copies of existing workbook

    I have an Add-ins Menu Bar (which works fine) defined and processed in "ThisWorkbook" using the code below: The issue is that I need to have multiple copies of this workbook open at the same time. To get multiple copies of the workbook I copy the original existing workbook save it as a...
  2. JenniferMurphy

    Can't get MrExcel HTML Maker to work on my Excel 2007

    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...
  3. Johnny C

    Add-ins manager automation button

    Has anyone ever used one of the options in the automation add-ins? Just wondering why they might be useful, is there anything useful in there or is it just another Excel white elephant
  4. L

    Excel 2010 Error Message: Initialization of the data source failed

    I have Excel 2010 (32 bit), Windows 64 bit. Power Query and Power Pivot add-ins installed. My co-worker has the same Excel and Windows, but does not have the add-ins. I created Power Pivot pivot tables and inserted slicers to control the dashboard. Everything works fine for me (no error...
  5. O

    Excel Add-in but it won't display under the Add-in tabs

    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 >...
  6. H

    Add-Ins

    Can someone explain Add-Ins to me? What they are most useful for, etc?
  7. B

    How do you Assign a Macro Function to a Barcode

    Hi, all! I've been doing some research on trying to have a macro function run when a barcode is scanned. The only ways I've been able to find online involve downloadable Add-Ins - is there anyway to do this without installing an Add-In? Thanks, as always, for all the help! Best, bob
  8. S

    Macro beginner questions

    Hi, Over the last week I've been teaching myself to develop very simple macros with goals of becoming a master one day. My questions in red are: 1. can anyone recommend beginner tutorial sites similar to this one that I've been using https://www.homeandlearn.org/index.html? 2. Ultimately, I...
  9. E

    add ins

    I hope to provide with more useful add-ins to Excel thanks in advance
  10. M

    Developer Tab

    Hey everyone, I'm new to excel and new to this forum, I have been asked to create a scroll bar and to do so you need to use the developer tab. I figure out how to put the tab on my ribbon but once I did that it appears to be missing some things inside the tab. Groups such as code, add-ins...
  11. A

    Windows 365 Excel 2016 - PowerPivot and Power View Add-ins

    Is there any way to get the PowerPivot and PowerView Add-ins in the 365 version of Excel 2016?
  12. srizki

    VBA question, Increase the last row to upload.

    I use a spreadsheet to upload data on Oracle using Add-Ins, but many times there are specific number of rows that are uploaded, let’s say I have 1200 rows to upload, and let's say 587 will upload, whatever I do. The upload sheet has a macro, that says that upload the rows where there is a flag...
  13. pleeseemailme

    Add-ins Disabled, Still Need to Run Macros

    Howdy, We have some terrible accounting software that can spit out data to an Excel file. I've been writing some macros to interact with this data and turn it into something useful. I've been testing it for the past few months now and yesterday I tried it out on another user's machine. I...
  14. S

    Updating Excel Add-in on network

    Hi everyone, Here's my delima, I have an add-in I'm deploying to my team, I'm placing it on our shared, network drive (I'll call this one "Production"). I want to do updates to this add-in in the future, without everyone having to re-install it. I will have a developer add-in (located...
  15. ask2tsp

    exceljeanie output looks ok in preview, mangled when posted

    Sheet1 <tbody> * A B C D E 1 2 3 4 5 label 2 * * * * 15 3 C 12,8 2,56 CCCCCCCCCCCC 30 </tbody> <tbody> Spreadsheet Formulas <tbody> Cell Formula A2 =IFERROR(INDEX(tblData,IFNA(MATCH($E2,indexList,0),""),A$1),"") </tbody> <tbody> Names in Formulas <tbody> Cell Name...
  16. D

    QB to Excel Report Updating

    I am looking for a way around a QB/Excel relationship that I currently have. Up till now I would enter a sales order into QB and save, I then open an Excel Workbook I created, and using the ODBC driver I would "Refresh Data" and update "sheet1" with all open sale orders in QB. Since updating QB...
  17. R

    Add-In procedure not working

    Hi, I have a daily report delivered in CSV format. I do a fair bit of manipulation in a series of macros and then save the file. When I run this on my PC it works fine. When I save the macros to an add-in file format so that others can access them, all of the procedures work except the...
  18. J

    Examine Add-in code

    Hi everyone, I am new to this forum so please excuse any formatting error and grammar. I would like to examine the Regression code in the Data Analysis Add-In. The reason being, I am examining multiple data for a company and instead of having to reuse the tool for each data set, I'd like excel...
  19. D

    Split a cell Diagonally and Treat Seperately

    Hi, I need to be able to split a cell Diagonally in Excel. Each half needs to have it's own formula, and based on the value of the formula needs it's own colour coded conditional formatting. I've looked for different add ins to allow me to do this but thought this forum may be the place to help...
  20. L

    PowerPivot - DRILLTHROUGH doesn't seem to help me, data does not pops out =/

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top