1. pedrowave

    New Rolling Calendar Control

    In old versions of Excel there was an add-in for a DatePicker Calendar Control that allowed dates to be entered into a cell from a monthly calendar. New versions of Excel don't include a DatePicker add-in out of the box, so add-ins have been developed by third parties to fix its absence, and...
  2. C

    How to modify code to update multiple workbook files which has the same format but different data?

    Hello excel programmers. I don't know if you can help me. Yet again, if you are comfortable to view the files below for testing. This is my concerned. I have a code for each of my workbook files below. (I have over 100 workbooks which has the same codes and excel layout, but different data)...
  3. M

    Add in troubles

    Hello, I have a very nasty problem with Excel. Excel adds a path to the function, i.e.: ='C:\Users\Me\Documents\water97_v13.xla'!tSatW(10) But than this gives a #NAME? error. When I manually remove the path, i.e.: =tSatW(10) Than the function works fine. I could manually remove all the...
  4. E

    Help me calculate the formulas for Data Analysis add-in

    Hi Guys, I have a big favour to ask. Within excel there is an add-in called “Data Analysis”, Which can do “Regression” I am able to get the Coefficients using the following formula as an array (if the ranges are set to be the independent and depend variable data)...
  5. glfiedler

    Userform in add-in must be clicked before it is "active"

    I have created an add-in that functions perfectly except for one annoying thing. The add-in creates a new workbook by copying the add-in's first sheet. This new workbook is then populated with data from an archived workbook that the add-in has opened. This works well and I can watch the data...
  6. MrDB4Excel

    Sequence Function

    I am not sure this forum is the right place to ask about this. I use Excel 2013 and have been looking for a downloadable add-in of the sequence function. Is there such an add-in? If so where can it be found?
  7. bfreescott

    Docking Station affecting add-ins?

    Hi all I have a client that uses a network-installed add-in. Several others use the same network-installed add-in without issue, but everyone works from a desktop that never gets disconnected from the network. Could undocking a laptop from the network break the link to the add-in? I have not...
  8. spacecaptainsuperguy

    very hidden sheets add-in

    Hi everyone, I used to have an excel add-in that had a form that allowed me to select multiple sheets from within that spreadsheet and select whether to hide, unhide or make very hidden the selected sheets. I recently upgraded my machine and office and that old add-in no longer works. I've...
  9. A

    VBA - Add In with Modules/Subroutines

    Hello, I am working with different tools based on workbooks at work. Now I don't want to write/update the code, which is over some workbooks the same, again and again in every tool. The solution should be to write this tool, which is exactly the same in every tool, in an add in, and connect...
  10. sparky2205

    Excel Inquire COM Add-in

    Hi folks, I inadvertently removed the Inquire Excel COM Add-in this morning instead of disabling it. Developer Tab > COM Add-ins > Highlight Inquire and press Remove. I'm trying to get it back but nothing seems to work. It no longer appears in the list of COM Add-ins. My ultimate remedy will be...
  11. M

    revision cloud add-in "cloud.xlam"

    I watched a youtube video by Amjad Pervaiz on making rev clouds in Excell. He had a add-in called "cloud.xlam" that would convert a rectangle to a cloud. He could adjust the arc radius, color, and line thickness. Does anyone know where I can get a copy of this add-in?
  12. M

    revison cloud add-in

    I need a copy of the revision cloud add-in named "cloud.xlam".
  13. J

    Trying to make an add-in to copy and paste values for every sheet

    Hi everyone, I need to make an add-in that copies and pastes the values of very sheet in the workbook. I tried running this code and it worked: Sub Saveasvalue() Dim wsh As Worksheet For Each wsh In ThisWorkbook.Worksheets wsh.Cells.Copy wsh.Cells.PasteSpecial...
  14. W

    Cannot run macro from add-in.

    First post to this forum. Familiar enough with computer stuff, but first time user of Excel. I'm doing this to help a friend. Excel 2010 on Windows 7 (Ultimate) running in a VirtualBox VM on Debian Linux Stretch My friend downloaded a free Excel add-in (in an 'xlam' file) which is to file...
  15. L

    Power Query Get Data From SharePoint Folder Pre-2016?

    Hello I've hooked an excel file up to a SharePoint folder on my o365 machine no problem. I'm trying to hook up colleague up as well - she has excel 2013 however and has had to download the Power Query add-in. The add-in doesn't have 'From SharePoint Folder' available under 'From File'...
  16. P

    Check if worksheet exists.... ?

    Trying to put a snip of code at the beginning of an Add-In I've created that will check to make sure the required worksheet exists before it tries to run the code (to avoid error). Below is not working. Any direction/guidance is appreciated. Dim sht As WorksheetDim wb As Workbook If wb Is...
  17. gravanoc

    Is Selenium worth using?

    I spent a while trying to find out if there is an up-to-date version of the Selenium add-in, but haven't had much luck. It's an add-in that allows VBA to manipulate Chrome and Firefox as object models just like IE. This would be tremendously useful since IE is not able to navigate some...
  18. D

    automating query in VBA

    not sure if this can be done, but every day I download data via an Excel add-in ("transfer data from iseries") which I beleive is a way to download data from AS400. Every day, I need to click the Excel add-in, enter my user name and password (which is painful) then i tell the admin to start the...
  19. M

    Using Workbook Functions in Excel VBA Add-in

    I am creating an add-in that adds an option to the right-click menu that will let me run my macros. I've used the functions found here but when this is saved as an add-in this functionality doesn't work anymore. What would be needed to fix this...
  20. P

    Custom Add-In causes Excel to crash on load

    I extracted some code from my project and created an Excel Add-In with it. The project now references the Add-In and everything seems to work fine, however if I completely close down Excel and try to open the project directly, Excel crashes. If I open some other Excel file or create a Blank...

Watch MrExcel Video

This Week's Hot Topics

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