Hi all,
I have a .txt file that contains header information. I would like to remove that information, save the file/create a new file, and put it in a different folder.
I'm not sure how to remove the first line. Here are the steps i am trying:
I need help on steps 4 and 5. Not sure how to remove/delete List[0] and then create a new file.
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
Edit: Then use PAD to Save As the Excel File.
Good luck!
Jeeeezzz
No chance of a terrorist attack with PDA is there ? 😂
I would record a Macro, just delete the first row surely.
I just find sending keys can be flaky, rarely I know but it does happen.
Thanks for this. I just opened the file in excel, removed the first row, and closed and saved it where I wanted.
Luckily the file formatted well coming across!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.