Create Before/After Query Update Events Returning a web query can be very handy. Unfortunately if you want to run any code when this refreshes, there's no native way to do this. We can, however, create an event for this with a few short steps. This will all be done inside the Visual Basic [...]
How to Import Access Data to Excel Using the “Get External Data - From Access” Option July 2013 Many people (especially in Finance) use Excel and Access almost interchangeably, feeding data between both applications. But if you've never done it, then how do you? There are several ways to import data from Access to [...]
Data Explorer for Microsoft Excel 2010 There's a new add-in for Excel called Data Explorer. Currently it's in preview (beta), so use at your own discretion and risk. What is it? Well the name really does say it all – it lets you explore data. Think of the current mechanisms we have in [...]
