Get VBA Code to find the MAC address for a computer. This VBA code will list the MAC Address of all the network adapters installed in your computer.
List all Network Adapter, MAC , Enable Disable Connection using VBA
List all Network adapters in a computer using Excel VBA. Get MAC address, Connection status, Name etc., Disable, Enable, On/OFF any Network adapter.
How To Sort by Color in Excel?
Learn how to sort by color in Excel using menu & VBA code. You could sort either by cell background color or the font color. Get this free code sortbycolor.
Disable Autofilter Excel VBA – Filter Switch On OFF
VBA Code to check if Autofilter is on or off in a worksheet or any sheet in the workbook. Get VBA code to check the status and also to toggle the autofilter
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 […]
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 […]
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 28, 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.