0

error message

Every time I open excel with give me that error message, old files or even a new file complete with no VBA no data no nothing yet. And it also pops up when I try to do a simply get data from a EIA add in. Any insights as to how to solve this?

Stela
  • 11
  • 1
  • 1
    What is this "EIA" add-in? – BigBen Feb 18 '22 at 15:34
  • @BigBen Sir, just found this on google search about `EIA` add-in https://www.eia.gov/opendata/excel/ – Mayukh Bhattacharya Feb 18 '22 at 16:07
  • Also i found there is an error notice given which reads as `Notice: As of February 11th, 2022: The API now only respond to HTTPS. Insecure (HTTP) web protocols are no longer supported.` – Mayukh Bhattacharya Feb 18 '22 at 16:10
  • 1
    If it's an Excel add-in (xlam), if it's password-protected and you're comfortable [cracking](https://stackoverflow.com/questions/1026483/is-there-a-way-to-crack-the-password-on-an-excel-vba-project) the password, you could probably debug further. – BigBen Feb 18 '22 at 16:12
  • It's either that add-in or a workbook in your `XLSTART` folder. – HackSlash Feb 18 '22 at 16:34
  • 2
    If you disable the AddIn, does the error still occur? – FunThomas Feb 18 '22 at 16:57
  • actually the error message appears as soon as I open the file. Any excel file even a new empty one. It just keeps showing if I try to do the add in. – Stela Feb 19 '22 at 00:15
  • so the "add in" can't be the problem. @HackSlash how can I check and correct the XLSTARt folder – Stela Feb 19 '22 at 00:18
  • @Stela The code would be visible in the VBE. The location is different on each computer. SEE HERE: https://answers.microsoft.com/en-us/msoffice/forum/all/office-365-location-of-xlstart-folder-andor/27d80806-7ec0-4d73-934c-6a73d8f4cdbf – HackSlash Feb 21 '22 at 16:08

0 Answers0