Browse File Dialog in Excel VBA In Excel file, if you are doing any folder operations or trying to read content from another text,xlsx, csv file. It is better to use this file dialog box rather than manually typing the file name with path. It would reduce the typing errors… [Continue Reading]
Get Excel VBA code to copy worksheet from one workbook to anotherworkbook. Also, after copying the sheet, you can rename or access it with a new object and it is easy to use this way.
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.
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]
- 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