sdllc
Error in get("BERT") : object 'BERT' not found
I've realing been enjoying BERT so far, however every once in a while i run into the same problem: sometimes I'm not able to use the functions I wrote with BERT, when I open the console I get the message "Error in get("BERT") : object 'BERT' not found"
I'm still able to use a few functions that I wrote today, but can't use my older functions and can't source them either. I noticed that the older functions make use of BERT$UsePackage(), maybe this is related?
I tried re-activating the add-in and re-opening Excel because I think this has solved this problem for me in the past. However this time I'm not able to solve it. Ever since I downloaded (and activated) the add-in I also got the same warning message whenever I opened Excel: "The file format and extension of 'BERT64.xll' don't match. The file could be corrupted or unsafe. Unless you trust its source, don't open it. Do you want to open it anyway?". I don't know if this has anything to do with the problem I described above, but just wanted to add this information in case it would be important.
Kind regards and thanks for this great add-in!
Regarding the second question, "The file and format...", that is because for some reason Excel is trying to load a 64-bit add-in in a 32-bit process (you are using 32-bit Excel). There is no reason that this should happen, though. Check your Excel add-ins list, and if there is an entry in there for BERT64.xll remove it (that's not how BERT works).
I'm not sure if that is causing the other problem, but it's worth a look.
Thank you for your reply. This weekend I already fully re-installed the BERT add-in and this has solved the problem. I think the problem was indeed related to the difference between the 64-bit and the 32-bit add-in