Macro to remove empty rows present in Excel Document based on the first column developed using VBscript for all the sheets present in the workbook.
Enter the following into windows cmd:
execute.vbs "path to the excel document.xlsx"
In my example:
execute.vbs "Excel-Macro\test.xlsx"
Note: Please pass the File Path with the double quotes included