add-in

  1. 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...
  2. 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...
  3. 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?
  4. M

    revison cloud add-in

    I need a copy of the revision cloud add-in named "cloud.xlam".
  5. 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...
  6. 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...
  7. 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'...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. W

    Worksheet Referencing Problem?

    Hi All, So I made a little program and now am in the process of making it into an Add-In. After it was loaded as an Add-In it did not work quite right. It was how the worksheets were referenced. I fixed all the bugs but this one. So what should be happening, and works fine when I'm not...
  14. K

    Reference Table w/i Add-In ???

    I have an add-in I have developed with some VBA code and 2 tables on different sheets. TableA is self contained (i.e. only relevant to the VBA code w/i the UDF in the Add-In). TableB is a Holiday table that I would like to distribute via the Add-In so other using the Add-In need not maintain...
  15. JenniferMurphy

    Moving code from one add-in module to another

    I want to move several UDFs from one module in one of my add-ins to another module in the same add-in. I created the new module and moved the code, but now all of the calls to those UDFs get a Name error. From what I have read, this is an addressing problem in that the calls have an invisible...
  16. D

    Using Add in Userform with multiple open Workbooks

    If this question has been asked before, then I apologise, I have been searching through forums for more than a year now. This is also my first post. I have created an Add-in which is accessed from the ribbon loading a Userform. All the code of all the things done by the Userform is located in...
  17. JenniferMurphy

    Conflict between Code Module and Add-In

    I have a UDF in an add-in module. I decided to make some changes, so I copied it to a code module in a macro-enabled (.xlsm) test workbook. It was all working fine until I closed the test book. When I reopened it, none of the calls to the UDF were getting executed. They all showed a Value error...
  18. JenniferMurphy

    Compare VBA code in add-in to that in workbook code module?

    How difficult would it be to write a macro to compare the code in a workbook code module to the code in an add-in? I sometimes give a workbook to a friend or colleague that depends on VBA code in my personal add-in. I don't want to give out the entire add-in for many reasons, so I usually copy...
  19. M

    Office Excel Add-in for Connecting to HANA/SAP

    I've tried re-installing the Connecting to HANA via Office Excel Add-in : Analysis -- but the Add-in isn't showing up on my Add-ins under Options in Excel. Anybody use the Analysis Add-in in Excel for SAP HANA and know any trouble shooting?
  20. JenniferMurphy

    Add-In modules vs Code Modules

    Is there a way to have an add-in module deactivated for one workbook, but still active for all other workbooks? The only way I know of to deactivate an add-in is File | Options | Add-Ins | Manage | uncheck the add-in in the list. This procedure causes that add-in to unchecked for all workbooks...

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