Get this code to rename a file in Python or list of files in a folder with simple easy way. Also, you can copy its content to a new file.
Enable Cut/Copy/Insert/Delete Options in Excel Right Click
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 […]
Fiverr Disabled – Issues with Freelancer Sites – My Experiences
November 27, 2024
Best Freelance Platforms As usual I signed up with lot of freelance websites like Upwork, Guru, Remote, Fiverr & Freelancer Out of all these, Fiverr worked out very well for more than a Year back in 2018. You can also make lot of money from these websites, just like how […]
Enable Disable Excel Command-Bar Options
Excel – Enable Disable Commands & Options There are about 150+ options available with the code presented in this section. The notable options are “Status Bar” and the Popup menu that appears when you right click on a cell or row etc., Using this code, those options can be switched […]
VBA File Open Dialog Box
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 […]
Excel VBA – Copy Sheet To Another Workbook
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.
How To Speed Up Excel VBA Macro Execution Time – Optimize?
Speed up Excel macro using these optimization technique. Using this the Excel VBA macro run time is reduced making it more faster than before.
Convert Number to String in Excel VBA Macro Code
VBA code to convert number to string. Convert variable of data type integer/float/double to a string value, so that the assignment or IF condition between different data type works fine.
VBA Option Explicit Not Working – Solved
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.
VBA to Delete File in a Folder
November 27, 2024
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.