Speed up Excel macro using these optimization technique. Using this the Excel VBA macro run time is reduced making it more faster than before.
Get the command to convert a number to string. Convert variable of data type integer/float/double to a string value, so that the assignment or IF works.
Is Option Explciit not working in your code as desired. Undeclared variables are not reported. Here is the fix to make Option Explicit to work as desired.
Get VBA code to delete file from a system folder. It uses filesystemobject.deletefile function & the VBA.kill function. Both uses the filepath as parameter.
Get Excel VBA code to list all the defined names in the workbook. This code will also get the formula, comments, value along with the defined name.
Creating Defined Name with Formula in Excel Defined names or Custom Formula are used to simply the long formula into a short & meaningful name. These names can be defined in Excel from Menu -> Formula -> Name Manager -> New There are four parameters to define a Name Name… [Continue Reading]
Get the Python code snippet to check whether the string passed as parameter is Palindrome or not.
How to scrape Website using Python BeautifulSoup? Applicable To: Python 2.7, 3 or above Data scraping is a method to get data from the websites for business purposes, analyzing and countless purposes used by businessmen and programmers. Python provides best of tools and libraries for carrying out data scraping work…. [Continue Reading]
Convert Number Format or Currency Format This is something I learned today. One of my friends called me for a help. He has Excel sheet with numbers like this. 33,32,100 and 31,10,100 – Typical Indian Currency format If we select 2 or more cells with numbers in it, Excel displays… [Continue Reading]
Learn how a Key Logger is coded using VB6 with just simple code & then how it can be used to record the key strokes by running at the background
- Games VCF Countif Record Macro Timer in Excel Task Manager print screen HTML Table Import Data Thumbnails Text to Speech TTS Candy Crush Block Apps in FaceBook C++ Programing Machine learning AI bulk email Excel VBA vba color index vba color codes Android social media Twitter Google+ Google Adsense Tips bitcoin Calendar in Excel outlook vba mass email Data Mining Excel Macro Facebook WhatsApp python Wordpress