Archive for the ‘VBA’ Category

VBA Macro to Convert Dates in a Range – the Dirty Way

November 1, 2011 by marco · Leave a Comment
Filed under: Snippets, VBA, mySQL 
Social Tagging: • •

I used this hacked Excel-Macro to convert all dates in a selected range from a manual data import using Excel to generate all required INSERTs for our MySql database from 03.08.2011 16:51:01 to 2011-08-03 16:51:01 In case you wonder, where you can find your Visual-Basic editor and execute your VBA-code… follow these instructions. Here is [...]