R – Reference environment & settings commands
A list of commands I have used in R for information about the environment or general settings.
Read moreProgramming
WordPress – Links (Reference…)
Useful links:
Read more
WordPress – Google Analytics (ga) tracking code as a plugin
For wordpress sites I build, I insert the google analytics (ga) tracking code into the html head section via a plugin. I prefer this ‘cleaner’ approach of separating the code into a separate file. I also use the Wordpress function ‘is_user_logged_in’ to remove most of my visits to the site as I am typically signed in to my WP admin account. This post describes the steps I use…
Read more
WordPress – Child Theme Steps
Summarizing the steps explained in the WP Codex for creating a child theme.
Source:https://developer.wordpress.org/themes/advanced-topics/child-themes/
Read moreWordPress – Steps to import MySQL DB from online host to localhost
Steps I use to import data (ie posts, settings info etc) from my online hosting account to the MySQL database
Read moreVBA – Excel – Tips on Learning VBA
Every now and again I am asked what is the best method to learn VBA. On this topic here are
Read moreConfigure local server to use cloud service
Here I describe my own local server setup which uses XAMPP, MySQL and OneDrive. Using a local server to manage
Read moreVBA – Excel – Count the Number of Matching Words in Two Strings
Possibly useful to sort, order or compare lists of non-identical but related strings.
Read moreVBA – Excel – Routine to position shapes in range
Routine to position shapes in worksheet based on specified ranges. Note: Can use ‘print shape name‘ routine to create required
Read moreVBA – Excel – Print All Shape Names Routine
Routine to list names of shapes in specific worksheet or current workbook. Can make adjustments here to list various shape
Read more