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,…
Hello World! Excel VBA
I find Visual Basic for Applications most useful in Excel. I have created many small enhancements to make my larger…
Microsoft Excel CSV export options
When busy with a data migration where I needed to export Microsoft Excel workbook data to CSV for import into MySQL,…
Read a Word doc using COM
So I managed to write a script to read a Microsoft Word document using PHP CLI and the COM object…
Display the full pathname of a Word document in the Title Bar
I have to have multiple Microsoft Word documents open when I am marking CAT practical assessment papers. As I have…
PHP Dynamic year selector
Another post from the archives. After 2009 rolled in and all our sites failed to follow suite because “someone” hard-coded…
PHP CLI “Hello World”
I have only recently begun working with PHP CLI scripts. Executing PHP scripts from the command line is fairly easy…
PHP short tags
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
Creating an Excel template for the Google Form Builder for Sheets add-on from Jivrus Technologies. Do not change the template…