Visual Studio – Existing workbook project
The error: ‘The project cannot be created’ When trying to create a new Excel Workbook project in Visual Studio 2013, I kept this error back from VS. The simple fix was […]
PHP – The Lost Sessions
After wasting the best part of a weekend trying to find out why my web app was losing Browser looking for files that weren’t present.
Powerpivot Refresh
I have a large Powerpivot spreadsheet with around 10 tables – some with 10million rows of data. My code cycles through various Slicers to change the views and produce reports from it. Each time the slicer value is changed, the sheet has to pull th…
Improving the quality of Excel image export
As part of a BI solution I’m developing I need to export ranges and PivotTables to image files for inclusion in emails and on webpages. There are many code snippets out there on the web that allow you to do this by copying the range to a new chart…
Creating Scientific Notation in VBA – PowerPivot Automation
I’m building an Excel-based BI tool using PowerPivot and needed to automate the changing of some slicer values to produce different report contexts. The values in the slicer are all simple integers (in the source SQL database too) and when used in…
Windows Virtual PC and Old XP boxes
I thought it might be a good idea to turn an old XP installation into a Virtual PC, just in case I ever wanted to go back and have a look at something, or use some of that old XP software… Whilst that seems like a great a idea, there isn’t a sim…
Windows Server 2008 FTP Upload problem
In a previous post, I mentioned problems I was having with a backup program I have running for clients. As it turned out, the issue wasn’t with my LFTP build, but something more tricky to track down… I’ve installed FTP 7.5 onto my server (Window…
LFTP for Windows
I’ve been using a version of the excellent LFTP (v3.7.6), command line FTP client for Windows as part of a more complex backup program I’ve written. Recently, my program stopped working as expected, so I began investigating. One line of investigat…
Squeezing the most from IT 