Changing Excel’s ActivePrinter using VBA isn’t as straightforward as you might think. In particular there is a localization issue.
Normalize data: from Userfriendly to Pivotfriendly
2013/12/08 By 3 Comments
If possible I always use pivottables to create reports in Excel. Pivottables need well formed, normalized data tables as source, which are usually not suitable for data entry. In this post I describe two techniques to bridge the gap between userfriendly and pivotfriendly data structures.
Pivottable data connection models
2013/11/20 By 1 Comment
The way a datasource connects to a PivotTable depends on the datasource. In this post an overview of the six connection models that you can create by means of Excel’s userinterface.
Excel and XML: four observations and two bugs
2013/10/22 By 1,325 Comments
I have been working with Xml files in Excel for some time now, and thought it is time to share some observations.
Create Xml from Schema
2013/10/04 By Leave a Comment
In this post I describe a tool to create an Xml file from a schema (Xsd) using VBA and the DOM and SOM objects of the Microsoft XML library MSXML version 6.
Recent comments