How do you copy rows from worksheet that's protected in Excel file A into a non-protected table in Excel file B?

[Blewis21]

I'm trying to take data from a protected excel file I get once a week, but I'm unable convert it to a table and 'add a row' in the excel file B. 

Whats the best approach to get data from the protected worksheet since 'create table' is being blocked from the protection?

manually this is what I would do....

1.) select the range

2.) copy

3.) create new worksheet in excel A

4.) paste into a new worksheet

5.) turn what was just pasted into a table

getting the data into excel B I think I have down for the automation part, just need help on getting around the protected sheet part

[Pstork1]

You can't use Power Automate to process protected Excel files.  You could try building a UI Flow to scrap the information off the screen while you are in Excel and send it to Flow.  But that's the only real workaround at this point.

[RTB_10]

Perhaps there is way to do this using Office Scripts as part of Power Automate?