ODBC MySQL Data connection in Excel
After swatting up on connecting QlikView to a MySQL database, I used the knowledge gained to create a similar set-up,…
productivity through technology
After swatting up on connecting QlikView to a MySQL database, I used the knowledge gained to create a similar set-up,…
I find Visual Basic for Applications most useful in Excel. I have created many small enhancements to make my larger…
When busy with a data migration where I needed to export Microsoft Excel workbook data to CSV for import into MySQL,…
So I managed to write a script to read a Microsoft Word document using PHP CLI and the COM object…
I have to have multiple Microsoft Word documents open when I am marking CAT practical assessment papers. As I have…
I decided to use the HTML5 <input><datalist> on a View in my CakePHP project, and was super surprised to see…
Another post from the archives. After 2009 rolled in and all our sites failed to follow suite because “someone” hard-coded…
I have only recently begun working with PHP CLI scripts. Executing PHP scripts from the command line is fairly easy…
Another post from the archives: I am running a WAMP development environment at home and at work. I am always…
Creating an Excel template for the Google Form Builder for Sheets add-on from Jivrus Technologies. Do not change the template…