I’m proud to announce the stable release of Newton, my personal VBA codebase which I have been developing over the past month. Putting this up here is as much for sharing as it is safekeeping. Newton comes with handy functions for handling large arrays of data, as well as some useful file input-output stuff. It [...]
I have shared some code I was working on in the past previously. I have since modified it a bit further as I learned more about excel (both 2007 and 2003) and also about my financial data reporting needs. I’ve taken to calling it Newton Utilities as, like Newtonian physics, the functions included are not [...]
The highest-end iPad is S$1,108 and AppleCare (for any iPad) can be purchased for S$118, or just over 10%. What AppleCare does is extend your phone support, by 1 year 275 days, 90 days from now, and your hardware support, by 1 year, 1 year from now. Rings a little like a good old Credit [...]
usggovi dataAn extremely common problem encountered in VBScripting is having to copy to and from the Clipboard. VBScript does not offer direct access so there are many workarounds suggested. Most of what I find on the net are half-solutions involving security warnings from everybody’s favorite browser. This is my stackoverflow.com solution to the problem. Code [...]
Also self explanatory? Private Sub swyxVBAPivotTable(inputarray(), rowlabelsBase1(), valuedataBase1(), outputarray()) Dim x, y, i, j, sb, WIA Dim prelimarray(), listofcols() x = UBound(rowlabelsBase1) y = UBound(valuedataBase1) ReDim prelimarray(1 To x + y, 1 To 1) ReDim listofcols(1 To 1) ‘just the first one, special treatment sb = “” For j = 1 To x [...]
.
