New Links, and an Update

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

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.


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:

(Spot the notable omissions!)


Everything you ever wanted to know about timber roof framing (and then some):

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.


And Finally, Andrew Engwirda has moved and re-vamped his blog: :

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!

This entry was posted in Computing - general, Excel, Javascript and tagged . Bookmark the permalink.

4 Responses to New Links, and an Update

  1. Hi Doug,

    Thanks for the link. It’s very much appreciated!


  2. Jon Peltier says:

    Jan Karel’s last name is Pieterse.


  3. excel1star says:

    By the way – VBA Compare can be used with XLSM Workbooks if you post fix .XLS to the file name.
    Alfred Vachris


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.