Excel VBA WS Overview
Document Sample


Excel VBA WS Overview
References for VBA
Robert de Levie Advanced Excel for scientific data analysis Oxford 2004
(around $60 in paper).
Exellent discussion of VBA and something of its evolution.
Tons and tons of good examples
Tons and tons of useful routines already debugged, downloadable from Oxford's site
www.oup-usa.org/advancedexcel
Paul Kenton's VBA site www.vbaphysics.com
Course notes for Computer Applications in physics.
A huge treasure of VBA instruction, mixed with physics problems and examples.
He writes it's fine to use his stuff, but if any financial gain is involved, he should be
compensated.
Kimmel, Green, Bullen, Bovey, Rosenberg and Patterson. Excel 2003 VBA Programmer's Reference
Wiley Publishing, 2004
Gets into the guts of VBA. Lots of stuff you won't need and quite a bit that could be useful if
you need to do special stuff.
Matrices Gee-Whiz examples
Euler angles
Transmission coefficients
Simple Matrix activity for participants (1-D rotation matrix)
Justin Kay Video Analysis
Discuss some features of the code briefly
Object Browser
VBA Gee-Whiz examples (brief show-and-discuss)
FFT from de Levie
pick N to be analyzed (slider)
pick start point in data (slider)
do the FFT
transfer data to top where it is plotted
Graph innards
square graph
scroll through data with a slider (change max and min with sliders)
VBA loops (loop over frequency for a graph of transmission coeff vs. freq)
Get documents about "