Fully Functional code that can fetch you folder list along with its size. This helps ur to find empty folders in our system. Once we get the list, we can remove the empty folders and on the other hand if the folder size is so huge, we can dig in and find why it’s size is so much huge.
Add a Command button in Excel worksheet from Developer tab or Quick access toolbar. Add Command buttons or Calendar to design your Worksheet with VBA code.
Send Email from Excel VBA to Multiple recipients using Outlook. Learn how to send bulk Email from Outlook using Excel VBA to multiple recipients. Mass Email
1. To know how to insert the Calendar Control in worksheet, read the below topic. http://officetricks.com/insert-calendar-control-in-worksheet/ 2. After inserting, how to get the value of selected date into a cell. Press Alt+F11 and insert these codes. Private Sub Calendar1_Click() ‘Thisworkbook.sheets(SheetIndex or “SheetName”).cells(Row#, Column#) = ValuesToEnterIntoCell ThisWorkbook.Sheets(“Sheet1”).Cells(1, 1) = Calendar1.Value End […]
Learn how to insert a calendar control into your worksheet. Easy to pick date from the date picker control & display it in the worksheet. Install MSCOMCT2.ocx
Learn how to remove duplicate values in Excel using Excel VBA, Formula & Google Spreadsheets formula & highlight duplicate entries. Find & remove the duplicate entries from Excel & Google Spreadsheet easily.
Learn Excel VBA Hello World Macro code for beginners with step by step guide. Get to know how to Code, Execute a VBA code & get results. First step of Excel VBA Macro is to first learn this Hello World program.