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 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. [code language=”vb”] Public Function MatchingWordsInStrings(InString1 As String,
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 moreWordPress – Adding programming code to a post
Documentation covers this in detail: https://en.support.wordpress.com/code/posting-source-code/ Notes: Use ‘Text’ tab in post editor to avoid unnecessary formatting tags being added
Read moreVBA – Excel – Routine to Show All Worksheets (ie Make visible)
When there are a lot of hidden worksheets, making them visible one by one can be a pain. Stick this
Read more