Best wordpress plugin to clean and optimize database


When you uninstall a plugin/theme on wordpress, either manual or automatic, many times it doesn’t get removed completely. Some support files of that plugin/theme/app still left in your wordpress MySQL database. They don’t serve any purpose as their parent application (plugin/theme) is uninstalled. As your site gets older, you may install and uninstall many plugins and […]

VBA code to remove white spaces from a string in excel


VBA code to remove white spaces from a string in excel. Simple method is, use Replace() function.



VBA code to print a string in double quotes in excel


Below is the VBA code to put double quotes (quotation marks) for a string in excel. We can use CHR() function to print special characters like double quotes in excel VBA.

Example: Below is the VBA macro to print a string in double quotes (quotation marks (” “))


Easy steps to install Python on Windows


Below are the easy steps to install python on Windows (I tried with Windows 10). Install Python (Download it from on your C drive Search PowerShell from Start menu or Windows search box. Click on it to open. Type python in your PowerShell (Terminal) If you get any error or python is not recognized, then […]

Simple steps to install openpyxl on Windows

Openpyxl is a python library to perform read/write excel xlsx/xlsm/xltx/xltm files. Below are the simple steps to install openpyxl on Windows Click below link to download openpyxl package Download openpyxl package Extract the downloaded TAR file (recommended to extract it to python folder on C drive) Open command prompt or Powershell Navigate to the folder that you […]

Page 4 of 11« First...23456...10...Last »