If you are a SEO junkie like me then you cannot find enough ways to improve your website's loading speed. Checking your PageSpeed score is one way to do that.
Continue Reading: Get your Google PageSpeed score using VBA »
About JP
I'm just an average guy who writes VBA code for a living. This is my personal blog. Excel and Outlook are my thing, with a sprinkle of Access and Word here and there. Follow this space to learn more about VBA. Keep Reading »
Get your Google PageSpeed score using VBA
Attach current workbook to open email
In Attach Current Workbook to Current Email Doug Glancy has some VBA code to attach the current workbook to an open email (using the Outlook object model). It's early bound, but it is simple to convert it to late bound.
Continue Reading: Attach current workbook to open email »
Reference latest version of DBEngine
In How to get most recent DBEngine object, Access MVP Alex Dybenko shows us some VB.NET code for grabbing the latest version of DAO's DBEngine Object.
It smartly uses a loop to start from the newest version and walks its way down to the lowest version, trying to set an object reference each time. But the VBA version of the same code just hardcodes each version. Why not loop in VBA as well?
Continue Reading: Reference latest version of DBEngine »
A small experiment in comments
Apologies in advance for this off-topic post. I assume nobody noticed, but comments on articles over 90 days old will now automatically close.
Continue Reading: A small experiment in comments »