-
Recent Posts
Recent Comments
Archives
- Jan 2021
- Oct 2020
- Sep 2020
- Jul 2019
- Jun 2019
- Apr 2019
- Jul 2018
- May 2018
- Apr 2018
- Mar 2017
- Feb 2017
- Jan 2017
- Sep 2016
- Aug 2016
- Jun 2016
- Apr 2016
- Jan 2016
- Sep 2015
- Aug 2015
- May 2015
- Oct 2014
- Jul 2014
- May 2014
- Apr 2014
- Jan 2014
- Sep 2013
- Aug 2013
- Jul 2013
- Apr 2013
- Mar 2013
- Feb 2013
- Nov 2012
- Oct 2012
- Jul 2012
- Jun 2012
- May 2012
- Mar 2012
- Feb 2012
- Jan 2012
- Dec 2011
- Nov 2011
- Oct 2011
Categories
Meta
Tag Archives: Excel
Querying Text/CSV files in VBA, method #3: Power Query
The module PowerQueryText.bas contains VBA code to query text/csv/tab delimited files and return tables to worksheets. Continue reading
Hello (the rest of the) World – reading data in other languages
Have you ever opened a text file in Excel and found that the characters looked weird or corrupted? The Wikipedia entry for mojibake says ‘In German, Buchstabensalat (“letter salad”) is a common term for this phenomenon, and in Spanish, deformación … Continue reading
Conditional compilation VBA Excel Mac/Win/32/64…
To make my addin handle all the combinations of Excel 2007 onwards on Mac and Windows, 32-bit and 64-bit, I ended up with this conditional compilation block. The example I use is GetTickCount() but the principle applies to other declarations. Microsoft … Continue reading
Modeless Userform not terminating
One way to display status messages as a long procedure runs is to show a modeless userform and update it with text or a progress bar showing percentage completed. I was having a problem with Excel crashing, particularly Excel 2013, … Continue reading
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
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
Eusprig 2014 Delft – For Excel Builders and Inspectors
Thursday 3 July 2014, Delft, the Netherlands. And it’s FREE thanks to our sponsors! This is for the two sides of the house – those who use spreadsheets to solve their problems, and those who are concerned about the risks … Continue reading
Posted in Uncategorized
Tagged Audit, development, eusprig, Excel, research, risk, spreadsheet, test
9 Comments
Chart defined name oddity
I’ve seen this before but can’t remember where. It was discussed on the Excel-L list starting 15 Oct 2012 with the subject line “charting challenge: cannot change title’s (formula) reference to a worksheet cell” Try this in Excel 2010: in … Continue reading
Posted in Excel/VBA
Tagged bug, Chart, defined name, error, Excel, named range, oddity
Leave a comment
Open Source Data Visualisation Add-in includes Treemap
In answering a question on the Excel-L list, I discovered Fabrice Rimlinger’s Open Source Excel addin for data visualisation. Although it’s called Sparklines for Excel, it has more than that, and the code is GNU public domain.
Posted in Excel/VBA
Tagged addin, color, Excel, OSS, pattern, public domain, Treemap
Leave a comment
Conditional Format recalc oddity
This came up on the Excel-L list recently – maybe some reader can explain it. The requirement was to base a Conditional Format on a user-defined expression entered as text. The easy answer is for them to enter it as a … Continue reading
Posted in Excel/VBA
Tagged anomaly, Conditional Formats, Eval, Evaluate, Excel, FormatConditions, literal text expression, XLM
Leave a comment