Recent Comments
Category Archives: Excel
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 … Continue reading
Posted in Computing - general, Excel, UDFs, VBA
Tagged download security, Security certificate, VBA macro block
1 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 … Continue reading
Posted in Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, PyPardiso, Python, PyXLL, SciPy, sparse matrices, sparse solvers
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 … Continue reading
Posted in Computing - general, Excel, Link to dll, Link to Python, VBA
Tagged Add-in problems, Excel, Link to Python, Regedit, Remove add-ins, VBA, Windows registry
Leave a comment
Getting Excel Solver working
Recently I found that for unknown reasons the Excel Solver add-in was not working. Opening the add-ins list from the Devloper tab showed that it had become deactivated (also accessible from File-Options-Add-ins): Clicking the Solver check box returned a message … Continue reading
Posted in Computing - general, Excel
Tagged Excel, Office 365, Solver add-in, Solver disabled
Leave a comment
Listing Python modules and getting help docs from Excel
Python functions include detailed help documentation but to access this you need the full path to the function, including the names of all code modules and submodules. This post looks at how this information can be found using Excel with … Continue reading
Posted in Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, Function help, Getmembers, Numpy, Pkgutil, Python, PyXLL, SciPy
Leave a comment
