Tag Archives: VBA

UK HMRC MTD OAuth2 Excel/VBA demo

I’m making available as open source my VBA routines for the “Hello World” tests on the UK HMRC “Making Tax Digital” (MTD) web service which use oAuth2 and JSON. Thanks to posts from Bruce McPherson (Excel Ramblings), Tim Hall (Excel-REST), … Continue reading

Posted in Excel/VBA, Open Source | Tagged , , , , , | Leave a comment

A first look at the FUSE spreadsheet corpus

Following on the first paper by Titus Barik et al static.barik.net/barik/publications/msr2015/PID3640389.pdf and some work by Mark Townsend analysing the last row and column used in each file http://markstownsend.com/what-are-all-the-rows-for/index.html I downloaded the 7GB of 249,376 files and did some summary analysis … Continue reading

Posted in Excel/VBA, Research | Tagged , , | 1 Comment

VBA in the spreadsheets from the Enron email corpus

The European Spreadsheet Risk 2015 Conference papers are now available at http://www.eusprig.org/papers-presentations.htm My presentation was on investigating the use of VBA in spreadsheets in the Enron email corpus. http://www.eusprig.org/presentations/VBA%20in%20spreadsheets%20from%20Enron%2CPO%27Beirne%202015.pdf Most of the slides deal with the mechanics of how I … Continue reading

Posted in Excel/VBA, Research | Tagged , , , , | Leave a comment

Excel VBA Copy Range, Paste as Table to Powerpoint 2010/2013

So, I’ve spent the last couple of weeks trying to get that one right. Piecing together all the hints from stackoverflow and the rest, I find that I have to use the ExecuteMso method available in PP2010 and later, and use … Continue reading

Posted in Uncategorized | Tagged , , , , | 22 Comments

Dictionary VBA Class update

I’ve uploaded a new version of the Dictionary Class and a helper KeyValuePair Class. This exposes the KeyValuePairs collection so iteration is now very fast, about 2 seconds to iterate 1 million items using a for each loop:   dim oKeyValuePair … Continue reading

Posted in Excel/VBA | Tagged , , , , | 40 Comments