Microsoft blocking VBA in downloaded files (or do they?)

Microsoft announced earlier this year that they would be automatically blocking macros in downloaded Office files (as a security measure), then recently they said they wouldn’t, then yesterday they said they would, but not right now.

For more details, plus numerous comments see:
Microsoft: Roll back of VBA macro block in Office is only temporary

For more details about what can be done about it, including details of how to add security certificates without spending a fortune see:
https://www.computerworld.com/article/3666951/nows-the-time-to-prep-for-microsofts-excel-macro-crackdown.html

How this will affect files downloaded from here, I am not sure, but if you have trouble using the VBA code in any of the download files, please let me know.

As for my opinion on how Microsoft have handled the whole thing, I’m appalled:

Posted in Computing - general, Excel, UDFs, VBA | Tagged , , | 1 Comment

Two new old live recordings

Two recordings of live concerts recently found on You Tube:

Sandy Denny singing Blackwaterside (BBC In Concert – Paris Theatre 16/3/72) :

The Pentangle, three songs recorded in Australia in August 1972:

Posted in Bach | Tagged , , , , , , | Leave a comment

Installing PyPardiso and speed of Scipy spsolve

I recently upgraded to Python 3.10, and because of some problems with my previous installation I decided to do a complete new installation using pip, which required installation of all the libraries needed for my various programs.

For my linear algebra functions based on the Scipy library I have also installed PyPardiso which provides substantially better performance than the Scipy functions for solving large sparse systems. As reported here I previously found I had to search for a non-standard conda library for the installation, but this time the latest documentation recommended installation with pip: pypardiso 0.4.1

Since PyPardiso calls the Intel MKL library, I installed this first, so my installation procedure was:

  • Install the MKL library: pip install mkl
  • Install PyPardiso: pip install pypardiso

Code for using the PyPardiso spsparse function (or optionally the equivalent Scipy.sparse function) can be found at: Installing PyPardiso.

Checking the performance of the equivalent functions, the pyPardiso spsolve function was found to be much faster than the Scipy equivalent, as previously reported at: Making Finite Element Analysis go faster – Update and PyPardiso.

The Scipy sparse.spsolve function was found to have reverted to the slower times reported at: Making Finite Element Analysis go faster … The change in performance is (probably) related to installation of the scikit-umfpack library, which I had not installed at the time of the tests, but even after umfpack is properly installed, the pyPardiso function is much faster than any option with the Scipy function.

Posted in Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , | 4 Comments

Removing Add-ins

Recently I had problems with an Excel Add-in that was still trying to run, and generating error messages, even after being removed from the add-in list and uninstalled.

After much searching and trying suggested methods that didn’t work, I finally found a method that did work at:

https://stackoverflow.com/questions/1946551/excel-add-in-doesnt-get-the-hint/1946607#1946607

Here are the steps:

  1. First, remove the addIn from Excel. After removing it, don’t reopen Excel yet
  2. Go to registry: Start -> Run -> regedit -> HKEY_CURRENT_USER\Software\Microsoft\Office\version\Excel\Options. Delete the registry of the addIn you want to remove. The data column will give you the hint.
  3. This is the key, remember to restart the computer to reset Excel. If you open Excel before the restart, it will register the AddIn in your registry again and you will need to start all over again

answered Feb 21, 2021 at 3:33

The original question was raised in 2009!

Posted in Computing - general, Excel, Link to dll, Link to Python, VBA | Tagged , , , , , , | Leave a comment

Australian election results

Australia now has a new government. Here’s what Billy Bragg thinks about it:

Posted in Bach | Tagged , , | Leave a comment