Some new links, mostly suggested by Al Vachris:
Jan Karel Pieterse has been freely providing some of the best Excel advice on the Internet for some years now, but he has escaped inclusion on my blogroll, possibly because his site is not actually a blog. Not that that matters; it’s well worth a visit, and is now on the list.
Other interesting links recently provided by Al include:
VBA Code Compare
http://www.formulasoft.com/vba-code-compare.html
VBA Code Compare allows you to compare and merge any Visual Basic code embedded into a VBA project (macros, sheet code, module code etc.). VBA Code Compare uses direct access for working with VBA modules. Thus, you don’t have to export the source code to a file for comparing and import the edited code back.
You can use this tool for comparing two versions of the same module or for working with the source code when several authors change the code simultaneously.
VBA Code Compare allows you to download the source code of two modules, compare them, synchronize (merge) different parts of code, edit the code before and after comparing and save the changes.
The interface of VBA Code Compare gives you a chance to view the comparison report in two side-by-side windows, and supports syntax highlighting of the source code of Visual Basic.
VBA Code Compare has its own File Manager consisting of two side by side windows. It allows for the comparing of two folders’ contents, loading files for further work, copying files and folders etc. You can control the list of files to be displayed in the File Manager by using filters.
VBA Code Compare is freeware.
Hyperpolyglot
http://hyperpolyglot.org/scripting
Scripting Languages: PHP, Perl, Python, Ruby
a side-by-side reference sheet
They also have similar pages for a wide variety of other languages:
Programming Languages Reference Sheets
syntax for common tasks in a side-by-side format
Scripting Languages:
PHP, Perl, Python, Ruby
Embeddable Languages:
Tcl, Lua, JavaScript, Io
Shell Languages:
Bash, Zsh, AppleScript, PowerShell
C Style Languages:
C, C++, Objective C, Java, C#
Pascal Style Languages:
Pascal, Ada, PL/SQL, SQL/PSM
Lisp Dialects:
Common Lisp, Scheme, Clojure, Emacs Lisp
Type Inference Languages:
Standard ML, OCaml, Scala, Haskell
Declarative Languages:
Prolog, Erlang, Oz
Concatenative Languages:
Forth, PostScript, Factor
Computer Algebra Software:
Mathematica, Sage, Maxima
Numerical Analysis Software:
MATLAB, R
(Spot the notable omissions!)
Web-Sketches:
Everything you ever wanted to know about timber roof framing (and then some):
http://www.geocities.ws/web_sketches/
This one isn’t just for roof builders, there is lots of good stuff on working with 3D graphics, including Excel worksheets and Javascript code.
Update:
And Finally, Andrew Engwirda has moved and re-vamped his blog:
http://andrewexcel.blogspot.com/ :
Welcome to my new blog.
Why the change?
Well, my old blog site was getting very tired. Comments were disabled due to the inability to fight spam effectively and I missed getting feedback.
After looking at some other blog companies, I decided Blogger was the best for what I wanted. Some editing of the CSS and the odd tweak here and there – and a new blog is born.
Now all it needs is some content, and I think you will like some of the stuff that is coming up…
There are some major changes coming to my site and some new add-ins will be available for download soon.
And I’ll be looking more at the analysis side of things – data presentation, charts, design and best practice, something I’ve not blogged about much before – it’s time to become a little more serious.
Stay tuned!
Hi Doug,
Thanks for the link. It’s very much appreciated!
LikeLike
Jan Karel’s last name is Pieterse.
LikeLike
Thanks Jon. Now fixed.
LikeLike
By the way – VBA Compare can be used with XLSM Workbooks if you post fix .XLS to the file name.
Regards
Alfred Vachris
LikeLike