installed

  1. A

    How Do I Get My Addins Ribbon Button To Display?

    I installed the MrExcel HTML Maker addin. I shows as installed in the OPTIONS>ADDINS dialogue, and it the manage addins dialogue it is checked. But how do I access it? I have no Addin's Button in my ribbon or the menu, although in the OPTIONS>CUSTOMIZE ribbon settings, "Addins" is checked. I...
  2. I

    Returning Non Zero labels and quantities Without arrays

    We have a database that keeps track of installed inventory and allows an auditor to record the type of inventory installed and the number that is installed. The auditor records this in a table that has all of the types of inventory populating a pull-down menu and a column to record the number...
  3. C

    MrExcel HTMLMaker installed but not showing on Ribbon

    I've installed (to XL2007 on PC laptop with Win10) and activated the MrExcel HTMLMaker Add-In as described on the Forum Rules page, and added the folder location as a Trusted Location, but still do NOT see it appear in the Add-Ins menu. :confused: :mad: I can see the XLAM project in the VBE...
  4. D

    VBA Run Time Error 424 Object Required

    I have am having trouble with this line in my macro below. Range("J2:J" & LastRow).Value = "=IFERROR(VLOOKUP(H2," & LCase(sh.Name) & "_rate,3,FALSE),"""")" The code is supposed to change the named range in the formula based on the sheet name. I can't figure out why I am getting this error...
  5. A

    Organize scattered, similar cell values into the same columns?

    Hi everyone! I've been struggling on and off for the past couple of days trying to find a way to come up with a solution to my problem with a large export of data I have. I will include some pictures with some arbitrary data to help explain what I have and what I'd like to do with the data, in...
  6. S

    Check If Ppower Query Is Installed

    Afternoon All, Is it possible to check if "Power query" is installed if it is not installed display message that is not and supress the error "Initialization of data source failed" ?. As my sheet can still work without power query Can you please put comments in any code, as i am still finding...
  7. I

    DoneEX message

    Hi, I installed a file which was DoneEx It was to allow me to insert a bar code ex. Basically it wasnt what i was looking for so i uninstalled it of which was Monday. Today when i open an excel file i see a message p[op up to say DoneEx could not be found and it shows me the path of where it...
  8. L

    testing if a font is installed using VBA

    I found the VBA code on the 'net to test if a specific font is installed or not, and it works ... most of the time. The code is - ------------ Sub Testit() myFont = "Free 3 of 9" If FontIsInstalled(myFont) Then Debug.Print "'" & myFont & "' is installed" Else Debug.Print "'" & myFont &...
  9. R

    Build new table from existing table

    Hiyas, I have a worksheet ("Plugins") that contains a table ("tblPlugins") with one of the columns ("Installed") having data validation that contains Yes/No. I'm trying to build a new table in a separate worksheet based on the condition that if the column ("Installed") has a value of Yes, that...
  10. M

    HTML Maker...??? Installed.. How to use it...

    Hello, I downloaded HTML Maker... Unzipped it.. Double clicked on it.. Excel opens up, Now what..? I don't see it installed as an Add-In... I had it installed many years ago, but things change over time.. (I've forgotten even how to use it).. Are there directions on how to use it?... I...
  11. R

    problem with fuzzy lookup

    Dear Friends, Earlier I installed Fuzzy LookUp in my laptop where Windows 7 was installed. There fuzzy lookup addin was running fine. Recently I installed in another laptop where windows 10 64 bit is installed. But unfortunately fuzzy lookup is not running. After click on Go no result is...
  12. P

    COMAddins

    Hi & Happy New Year 2018 Am i being too simplistic? Trying to check if a COM Add-In "BERTRibbon.Connect" is installed and if not ignore a line of code that then turns it off If Application.Addins("BERTRibbon.Connect").Installed = False Then GoTo jmp This doesn't work, and I guess because...
  13. N

    Run-time error 91

    Hi, I have a fresh installed Office 2007. When I open Excel, a pop up comes up saying there is an error: Run-time error '91' How do I remove it? Have reinstalled Office 2007 multiple times. Even installed Office 2003 n yet same problem. OS: Win 7 Pro
  14. E

    VBA: Install current workbook (XLSM) as add-in and activate

    Hello everyone, I have a question with regard to programming an installation routine for my macros/addin. I would like to add a button to my XLSM workbook (which contains several macros) with the following function: (1) on clicking the button, the XLSM workbook should be automatically saved...
  15. L

    importing data from access

    Hi I want to learn/practice how to important data from Access to Excel. I am looking for Access data base that I can download to practice for educational purpose. Do you have any idea from where I can download such Database? Also when I click on Data tab in excel, I see group of commands...
  16. D

    xps to excel

    Any one know how to convert XPS to excel? I am not sure I can do this with a program as work wont allow programs to be installed.
  17. F

    can vlookup jump to different table array on fill down

    Hi all, Thank you in advance for any help offered. I don't think what I'm trying to do is even possible. So I have a vlookup that looks for a software installed on a PC and if the software is installed it returns Yes and if not installed it returns No. On sheet 1 I have the PC names listed in...
  18. D

    Setting the Installed Property to True is failing for the AddIns Class

    I'm trying to make my VBA addins simpler to install for my co-workers so that they can install and update them to their computer with basically just the click of a button. I have been able to get the code to work fine for my computer and another co-worker's computer. But when I tried to...
  19. S

    Load and install addin problems

    I try to install an AddIn. When I use the code below it copies the addin-file to "C:\Documents and Settings\admin\Application Data\Microsoft\AddIns" before it will work. Why do I have to copy it? I want to install it and keep it where I've already placed it. If i use...

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