Saturday, May 25, 2013

Code Example: Creating Menu Buttons for VBA Add-Ins

Sure, you can write VBA code. Sure, you can add a button to spreadsheet to trigger that code. Sure, you can set that code to run automatically in the background after a certain action is performed. But, how do you set up an add-in so that nobody has to open and see a blank spreadsheet every time they want to choose to just run your code (perhaps on a different workbook than where your code resides)? Well, here's a good way to get started...

Thursday, May 16, 2013

Code Example: Oracle SQL Query for Yesterday's Data

Do you have any queries running against "yesterday's" (i.e. the previous business day's) data where you actually have to adjust every week to account for the weekend? Here's a simple trick to make this less painful on Monday morning...

comments powered by Disqus