Useful Python and VBA for applications scripts to automate routine.
-
Easy explanation of divisibility rules with examples in Python
Easy explanations for divisibility rules of 2, 3 & 9 with examples in Python.
Read more ... -
How to remove any custom tags from text (strings) using Python
BS4 and other tools allow to remove HTML tags (.decompose(), .get_text() etc.) but there are situations when strings contain some other markup which cannot be filtered out by standard tools. This function in Python allows to set the tag mask which needs to be removed and removes all occurrences.
Read more ... -
Unisender API functions in Python
A few functions in Python for Unisender email marketing automation. Tested on Unisender. Probably works on Selzy too (2022-2023).
Read more ... -
How to send mass emails directly from Excel using VBA without Merge
A version of this script has been used to create personalized emails for a list of clients. In my opinion this is much cooler than the in-built merge function because it allows to automate complex calculations and generate any kind of personalized email (even with HTML markup), attach files (which you can also generate on the go right before you send) and whatever else comes to your mind.
Read more ... -
How to check if a file exists in Excel-VBA
Today we will discuss different ways to check if a file exists in Excel-VBA.
Read more ...