So, I need help to write vba code from the start. I have a folderpath (C:Usersshubham.vashishtDesktopCollection BotRemoverow) that contains a lot of excel file
the format of these excel files are xlsx and filename formate is SBIN_9876 ( so first four digits are alphabets and after _ they are numbers) .
I want to write a vba code that takes specific files filename open it save the 4 alpbhates in COlI row 2 till last row with data (cola to check which is last row with data) and Numbers after underscore in colj row 2 and name COli row 1 as Bank name and COlj row 1 as account number.
this needs to be looped on all files in folder

I tried writing code but no luck please help