add-in

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

    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?
  3. 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...
  4. 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...
  5. 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...
  6. S

    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...
  7. 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?
  8. M

    revison cloud add-in

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

    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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

Some videos you may like

This Week's Hot Topics

Top