I’d like to make a automate copying and pasting several links from the page, to excel as a hyperlink on a cell.
The program would follow this kind of procedure:
- Focus on Window, Copy Link, Close that tab
- Focus on Excel, WINDOWS KEY DOWN, CNTRL+K, CNTRL+V, ENTER
- Step 1
I would have many tabs open in the window, so once it closes the last tab the next one will be ready once PowerShell is done in excel and returns.
I have never written in PowerShell, unfamiliar with its syntax, and language. Any insight would be appreciated.