add-ins

Hello, I have question regarding downloading data from database in MySQL to Excel. For my colleagues I want to make application in Excel that connects to my tables in MySQL and download data. They will need to install my add-in and I do not want to bother them with installation of ODBC driver...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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