installed

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

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