Category Archives: VBA

Combining text files

Posted on 01/04/2009 by dougaj4

Updated 3 April 2009. Following Jimmy Pena’s comments I have revised the code to read and write the files in one operation, rather than line by line. I have also added the option to add a numbered separator line between … Continue reading →

Posted in Excel, VBA | 10 Comments

Frame Analysis with Excel – 6; Beam end releases and actions

Posted on 29/03/2009 by dougaj4

Continuing from: Frame Analysis with Excel – 5; Large frames in Excel 2003 Download Frame3.zip – the download file includes complete open source code. The frame analysis spreadsheet presented previously has now been revised to deal with beam end releases (either rotation or translation) … Continue reading →

Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, VBA | 4 Comments

A Sort Function

Posted on 23/03/2009 by dougaj4

There is often a need to sort data within a VBA routine, but VBA does not have a built in sort function, so I recently had a look for what is on offer on the Internet. Chip Pearson has an … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , | 21 Comments

By Jingo

Posted on 18/03/2009 by dougaj4

Dick Kusleika at Daily-Dose-of-Excel recently posted a video of an animated bingo spreadsheet, using the Jing screen capture program. I had previously posted a still image of my Newton’s Cradle animation, which rather spoils the point, so here it is … Continue reading →

Posted in Animation, Excel, Newton, VBA | 1 Comment

Writing an array to a worksheet range – correction

Posted on 14/03/2009 by dougaj4

The Microsoft Excel blog has some tips for speeding up VBA performance in Excel 2007, which apply equally to earlier versions. The number 2 tip (which in my opinion should have been the number 1 tip, and probably the number … Continue reading →

Posted in Excel, VBA | 6 Comments