Recent Comments
Tag Archives: VBA
Worksheetfunction.Transpose – changed behaviour in Excel 2013 and 2016
It is (fairly) well known that when using Worksheetfunction.Transpose on an array in VBA the array must be no more than 65,536 (2^16) rows long, or it will return an error. Recently when using Excel 2016 (32 bit) I thought … Continue reading
Posted in Arrays, Excel, UDFs, VBA
Tagged Excel, Excel 2013, Excel 2016, Problems with Transpose, Transpose, UDF, VBA, Worksheetfunction
6 Comments
Opening and searching pdf files from Excel
The file PdfLink.zip (free download with open source code) contains two short but useful macros for opening and searching pdf files from Excel. The first is based on code from My Engineering World. I have just added a simple interface … Continue reading
Posted in Computing - general, Excel, VBA
Tagged Copy full path, Excel, Open pdf from Excel, Open Windows Search from Excel, Total Commander, VBA
10 Comments
ConBeamU 4.08
The continuous beam spreadsheet has had another update to fix a problem when point loads were applied to cantilevers, and the first support position was not listed as an output point. The new version (4.08) can be downloaded from: ConbeamU.zip … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA
Tagged ConBeamU, continuous beam analysis, Excel, moving load, Strand7, UDF, VBA
1 Comment
Importing Text Files; Unix Format
Text files generated on Unix systems have a different convention to denote the ends of lines to that used on Dos/Windows systems (see Newline for more details). This was causing problems with the Text-in2 spreadsheet, with small files being imported with … Continue reading
Posted in Excel, UDFs, VBA
Tagged convert unix to windows, Data types, Excel, extract numbers, importing text, Number formats, splitting text, UDF, VBA
Leave a comment
Solving non-linear equations with two or more unknowns – 5
This will be the last of the series on solving non-linear equations (for now). Up until now all the examples have had two unknown values, and two target values. This can be extended by making three changes to the code: … Continue reading
Posted in Beam Bending, Concrete, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA
Tagged Excel, ExcelPython, moment curvature, Newton's Method, Python, SciPy, SciPy optimize function, solving non-linear equations, tension stiffening, two or more objectives, two or more unknowns, UDF, VBA
3 Comments
