Recent Comments
Category Archives: Excel
Reinforced Concrete Section Analysis 7 – rectangular sections
Previous post The spreadsheets presented in earlier posts in this series have been simplified for use with rectangular sections with two layers of reinforcement. The functions EStress (for elastic analysis of stresses, strains and crack widths) and UMom (for the … Continue reading
Posted in Beam Bending, Concrete, Newton, UDFs
Tagged Beam Bending, Reinforced Concrete, Section Analysis, UDF, Ultimate capacity, VBA
3 Comments
A Question of Spelling
The Excel VBA routine below will check the spelling of the text in the current selected cell, and return either TRUE or FALSE in the adjacent cell to the right: Sub SpellChecksub() Dim Checkword As String, Result As Boolean Checkword … Continue reading
ImageMagick – Update and add IrfanView link
The picture indexing spreadsheet presented in the previous post has been updated: Comments can now be added adjacent to the file names, and these will be copied along with the Exif data The routine to copy the exif data to … Continue reading
Posted in Drawing, Excel, VBA
Tagged COM object, Exif data, ImageMagick, import pictures, IrfanView, ShellandWait
4 Comments
ImageMagick and Excel
Back from my holidays, with a hard disk full of holiday snaps, and looking for a program to extract the image data saved on the camera, and add comments. Not liking the offerings provided with the cameras, or any of … Continue reading
Drawing in Excel 6 – getting shape properties
Previous post One of the less than useful new “features” of Excel 2007 is that its macro recorder no longer records operations on shapes, which removes the easiest way to discover the exact names of shape properties, and how to manipulate … Continue reading
