MS Excel

1302, 2013

Dynamically Link to Excel From MS Access

By |February 13th, 2013|MS Access Tips & Tricks|0 Comments

Here is a quick and simple solution that will allow you to dynamically link to Excel from MS Access. This routine creates a linked table to MS Access from Excel, that will allow you to pull in the data from Excel and reference it as a table in Access. This can come in handy for […]

802, 2013

How To Pause VBA While It’s Running

By |February 8th, 2013|MS Access Tips & Tricks|0 Comments

Here is a quick and dirty snippet on how to pause VBA while it is running and executing a process. Say for instance you are setting a connection and closing another to an external source, and you need to pause your VBA for a moment of time for the exterior items to transition before continuing […]

2701, 2013

Convert MS Excel Formulas to Google Doc Formulas

By |January 27th, 2013|Google Apps Tips & Tricks|1 Comment

Converting a Microsoft Excel formula to a Google Doc formula isn’t necessarily the hardest thing in the world, but they aren’t the easiest either if you don’t know what you are looking for. I’ve been using Google Docs for a couple of months now and have found that there are some large differences with some […]

Signup For Our Newsletter
Want to be kept up to date with all the latest content?
Signup for our newsletter and we'll let you know when new content is available!
And don't worry, we hate spam too! You can unsubscribe at any time.
Never display this again