System Environment Variables using VBA These are some of the variables that are using by operating system. The well known example is the “PATH” variable that has all the path for major software executable files and reference files. This means that they Operating system will first search for a typed… [Continue Reading]
CSV File List – Rename Files in Folder Using Python This is a simple code snippet that I developed for one my recent project. The current name of list of files in a folder is given in a CSV file. Also the new name that each file has to be… [Continue Reading]
Enable Grayed Option on Excel Right Click Does some of the options on the right click command bar is disabled or grayed out in your Excel Worksheets. Though it is not very unsure for me why this happens often in my system, I could find out some workarounds to resolve… [Continue Reading]
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.
