I have downloaded Excel Sql Addin but I can not install it to Excel 2007, there is no new ribbon menu tab and I can not use it. It is ok with Excel 2016.
Please help me,my email: email@example.com
Thank for your help.
Hi, unfortunately I don’t have any possibility of testing it in Excel 2007. I would go with Jim’s suggestion of putting the AddIn in the Roaming AddIns folder. Be sure to add user/Appdata/Roaming/Microsoft/AddIns in Excel to your Trusted Locations.
Hi, I just added that today and had no problem. I downloaded and added the file SQLAddIn.xlam to the microsoft AddIns under user/Appdata/Roaming/Microsoft/AddIns.
Hope it helps,
Simply the best place to learn VBA!