Posted by
Andy Brown
on 13 January 2014
You can use VBA to extract data from web pages, either as whole tables or by parsing the underlying HTML elements. This blog shows you how to code both methods (the technique is often called "web-scraping").
Posted by
Andy Brown
on 25 November 2013
You can get at all sorts of system information within Visual Basic for Applications by using environment variables - this blog shows you how to get at your user's name, computer name and much more besides.
Posted by
Andy Brown
on 07 November 2013
A short blog explaining how to use Visual Basic for Applications to loop over enumerations.
Posted by
Andy Brown
on 01 November 2013
Range names can have either worksheet or workbook scope - this blog shows how to make sure that you're referring to the right range names!
Posted by
Andy Brown
on 01 November 2013
A short blog showing how to stop Excel hiding duplicate values for pivot table groups.
Posted by
Andy Brown
on 01 November 2013
The SUMPRODUCT function is one of the hardest ones to understand in Excel, but it's also pretty useful. This blog gives clear examples of how to use SUMPRODUCT for conditional sums, weighted averages and the like.
Posted by
Andy Brown
on 13 August 2013
A previous blog showed how to get Excel to speak to you; this one shows how to change the voice in which it does it!
Posted by
Andy Brown
on 12 August 2013
Deep within its bowels Excel contains a feature allowing it to read out the contents of cells (you can also get your VBA macros to talk to users). This blog goes to those deep places hidden within Excel!
Posted by
Michael Allsop
on 24 May 2013
Ever had the feeling that you're missing something obvious? This blog highlights one particular chart option that you may well have overlooked.
Posted by
Andy Brown
on 18 September 2024
If you have a colleague who trusts you, you could always betray this trust by sending them a workbook which misbehaves: it won't close and you can't leave it!
Posted by
Andrew Gould
on 23 April 2013
If you're using shared datasets to populate subreports in Reporting Services you might have encountered an error when you preview your reports. This short blog explains what the problem is and offers a few simple suggestions to work around the issue.
Posted by
Andy Brown
on 05 April 2013
How to store the name of each file in a folder in a SQL Server table using an Integration Services package.
Posted by
Andy Brown
on 04 April 2013
If your chart has more than a thousand data labels, this blog explains why you may experience problems.
Posted by
Michael Allsop
on 17 October 2012
Up, down, ceiling, floor or multiples… and you thought rounding numbers was simple!
Posted by
Andy Brown
on 01 October 2012
By default SSRS will create files with extension .rdl.data to cache data. This blog gives two and a half ways to ensure you're always seeing the latest data in a report.
Posted by
Andy Brown
on 06 August 2012
To make report navigation easier, you can create a 2-dimensional matrix of clickable links at the top of a report. This blog shows you how!
Posted by
Andy Brown
on 06 August 2012
Create a matrix whose row, column and data fields are all selectable from dropdown lists.
Posted by
Andy Brown
on 06 August 2012
A single report in Reporting Services can serve many masters. This blog shows how to allow a user to choose which data a report should display, using a dropdown parameter.
Posted by
Andy Brown
on 21 June 2012
If you're not sure when - or whether - you should be using report or group variables in SSRS, read this blog to find out how to speed up your reports and solve other problems.
Posted by
Andrew Gould
on 30 May 2012
This follow-up article to a previous blog describes how to label the data points in multiple series in Excel using VBA.