Tag Archives: VBA

Importing text files with VBA – 2

Posted on 15/06/2008 by dougaj4

Previous post The text file import routines and functions presented in the previous post have been modified with the following additions: Lines of text can be split into separate cells, at any designated character (e.g. a coma or a space) … Continue reading →

Posted in Excel, UDFs | Tagged , , , , | 7 Comments

Reinforced Concrete Section Analysis – 3

Posted on 30/05/2008 by dougaj4

Previous post -1 Previous post -2 The theory presented in the previous 2 posts in this series has been incorporated into an Excel UDF, allowing concrete and reinforcement stresses and strains to be evaluated quickly and easily for reinforced and … Continue reading →

Posted in Beam Bending, Excel, Newton, UDFs | Tagged , , , , , , , , | 8 Comments

Importing text files with VBA

Posted on 19/05/2008 by dougaj4

Importing data from other programs into an Excel spreadsheet, in the form of text files, is a frequent requirement in engineering and scientific applications.  Often the data will have been formatted to suit printed output and will require processing before … Continue reading →

Posted in Excel, UDFs, Uncategorized | Tagged , , , , | 12 Comments

Evaluate Function

Posted on 22/04/2008 by dougaj4

It would often be convenient to evaluate a function entered as text; for instance if we have the function for the deflection of a cantilever under point loading at the end: F*L^3/(3*E*I) then it would be convenient to be able … Continue reading →

Posted in Excel, Maths, UDFs | Tagged , , | 9 Comments

Ranges and Arrays

Posted on 04/03/2008 by dougaj4

Transferring data from a worksheet into a VBA routine, or the other way round, is one of the most frequent tasks carried out in VBA programming.  Fortunately there is a simple way to do it: In a subroutine: Name the … Continue reading →

Posted in Arrays, Excel, UDFs | Tagged , , , | 4 Comments