Recent Comments
Tag Archives: Excel
Extracting numbers from text – update
I have previously posted a spreadsheet with user defined functions (UDFs) using regular expressions to extract numbers from a text string (see Extracting numbers from text and regular expressions). I have now modified the Extractnums function to optionally return the numbers … Continue reading
Posted in Excel, UDFs, VBA
Tagged Excel, Extract number from string, ExtractNums, regular expressions, UDF, VBA
2 Comments
The meaning of = in Python
In VBA, if you have an array named a and a variant named b, then the statement “b = a” creates a new array b with the same size and values as a. If the values of either a or b are subsequently changed, the values of the … Continue reading
ConBeamU 4.13
The continuous beam analysis spreadsheet, ConBeamU, is now up to version 4.13 with some minor bug-fixes, and the addition of a non-linear option for the BeamAct functions. See ConBeamU for more details of the functions available in the spreadsheet. Download … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged BeamAct functions, continuous beams, Excel, non-linear analysis, Strand7, UDF, VBA
7 Comments
February Links
Two new links with valuable free resources: .net and office automation follies : including many advanced VBA resources. Thanks to Alfred Vachris for the link. AET VBE Tools : Tools for the Visual Basic editor from Andrew Engwirda (via Daily Dose of … Continue reading
Debugging with xlwings and PyCharm
The xlwings documentation covers de-bugging, but it is very brief and it took me some time to get everything working, so this article covers the process in a bit more detail. The details are affected by the editor being used, … Continue reading
Posted in Excel, Link to Python, UDFs, VBA
Tagged debugging xlwings, Excel, PyCharm, Python, UDF, VBA, xlwings
Leave a comment
