Reputation: 1
I am looking for a solution on how to automatically open an Excel hyperlink directly in incognito mode.
For example, say I have the following hyperlink in column A =HYPERLINK("https://www.amazon.com/s?k=" & H3, "AMR ALL") this will open a new tab in my default web browser (Edge) however I would need to open these types of hyperlinks directly in a private window or tab. I need to specify that there are hundreds of similar hyperlinks that I need to open (quite frequently) and it's almost impossible to copy & paste these links every time - hence why I'm looking for a solution.
I have already tried setting up a Desktop shortcut for Microsoft Edge that opens ion private (incognito) directly to the main URL i.e. =HYPERLINK("C:\Program Files (x86)\Microsoft\Edge\Application\msedge.exe" -in private "https://www.amazon.com/s?k=") however I will need the URL to pick additional information from a different cell in Excel i.e. H3 and then open the link in incognito. Not sure how I can achieve this and I would appreciate it if anyone would be able to help me out with this.
Thanks, everyone :)
Upvotes: 0
Views: 4304
Reputation: 1
3 Solutions:
Right-click on the link, and then press the letter "g" on the keyboard. It's almost as fast as just clicking the link.
Alt+Shift + Click on Link.
Download a Chrome extension Copy All URLs, then simply copy all URLs from the excel sheet and then open incognito and then click on that extension and simply choose option paste.
Upvotes: 0
Reputation: 11335
You could automate Excel using VBA.
You could take the URL from an active cell in an Excel sheet using ActiveCell.Value and execute the Shell command on a button.
Example:
Private Sub CommandButton1_Click()
Dim str As String
str = "C:\Program Files (x86)\Microsoft\Edge\Application\msedge.exe -InPrivate -url " & ActiveCell.Value
Shell (str)
Debug.Print (str)
End Sub
Please see the Output here.
Upvotes: 0