How to copy one unknown file name excel data to another stored(saved) excel file sheet?
Need to copy-paste one excel sheet to another excel sheet. I have stored one excel in a desktop folder and the new one will download a web browser. So I don’t know the new excel sheet filename? How do that?
You can use [Get Workbook Sheets] activity to get all the sheet names in the downloaded Excel files.
Sheet name will keep in the list variable.
If you know index of the sheet that you want to get sheet name, then you can use
[Get Workbook Sheet] activity.
Sheet name will keep in the string variable.
I hope this information will be useful for you 
Thank You. I’ll try and let you know.
Thanks for your time 