Edit: After deleting the row, use PAD Save As Excel to pick your path, filename, and extension (.xlsx .csv .txt, etc.)
Use send keys to navigate through Excel to delete the row and resave the file:
Those 2 are red because I don't have a filepath or filename variable.
Be sure to set the time between keystrokes on the 'Send Keys {Alt}()fao' to 100, as the Excel menu is just a little slower on hot keys. You could set all the send keys to 100 if you want to just give it more time all around.
So, walking through it: Make sure the window is the focused window before you start
- Control + Home will go to A1
- Control + Minus will try to delete, but should bring up an ask box for cell or row
- Alt + r selects entire row
- Enter clicks ok
Edit: Then use PAD to Save As the Excel File.
Alt f a o (notice alt is not held down, that is why fao is outside the parenthesis) is File -> Save As -> BrowseWait for the File Name text field elementFilePath and Enter will take the browse to the folder you wantWait 1FileName and Enter will save the file
Good luck!
