Author Archives: dougaj4

Restoring sound on an HP computer.

Yesterday the sound on my HP Omen computer stopped working for no apparent reason.  I found the video below, which fixed the problem: The video is short, easy to follow, and doesn’t need the sound working to understand it! The … Continue reading

Posted in Computing - general | Tagged , , , | Leave a comment

A problem with integers in VBA

A recent question at Quora asked: “Why am I getting an overflow error in Excel VBA when doing a simple arithmetic calculation like str1 = 24*60*30 where str1 is a variant or long or double?” I hadn’t encountered that problem … Continue reading

Posted in Excel, UDFs, VBA | Tagged , , , | Leave a comment

Indexing pdf files, yet again

Recent versions of Windows have provided indexing of file contents that allows for fast searches over the entire contents of your hard disk.  This includes pdf files, but the default filter file only works with 32 bit Windows.  It is  … Continue reading

Posted in Computing - general | Tagged , , , , , | Leave a comment

The answer to Life the Universe and Everything …

is 42, as is well-known: The actual question, to which the answer is 42, is not known, but a lesser known long standing question involving this number has recently been solved: The original problem, set in 1954 at the University … Continue reading

Posted in Computing - general, Excel, Maths, Newton, PyXLL | Tagged , , , , | 2 Comments

Plotting Mandelbrot

There are many sites discussing the Mandelbrot Set, but not many examples using VBA to plot the set in Excel, so here is my effort: The spreadsheet (including open source VBA code) may be downloaded from: Mandelbrot chart.zip Note that … Continue reading

Posted in Charts, Charts, Coordinate Geometry, Drawing, Excel, Maths, Newton, VBA | Tagged , , , | 3 Comments

Using conditional formatting with array formulas

A recent Quora question asked “How do I highlight the number closest to an initial number in a row in Excel?“.  The answer by Bill Jelen provides a good example of using conditional formatting with an array formula: In my … Continue reading

Posted in Arrays, Excel | Tagged , , , | Leave a comment

64 bit Excel and the Strand7 API

Back in May 2017 I posted a sample spreadsheet using the Strand7 API to allow Excel to read and write Strand7 node data and results.  A comment noted at the time that the spreadsheet was not working with 64 bit … Continue reading

Posted in Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, Strand7 | Tagged , | Leave a comment