How to copy Authorization key from browser Developer option

[Negi1984]

Hi All,

Can any body let me know if we can achieve the below mentioned goal using VBA or not ?

Below are the manual steps which I am performing now :-

1) We have a internal site in first step I am opening that site in browser

2) Type value in one of tab and press enter.

3) Now by pressing F12 key to open developer option.

4) Now click on network tab ---> Headers----->Authorization

5) Here I need to copy the bearer code and paste in excel sheet.

Looking for your expert suggestions.

 

[Trixterz]

Sounds like web scraping task and you need internet explorer browser to do this through VBA. If you have that then we would need the URL for the site or a copy of the web source code. But even with that said... this sounds like a lot of work.

 

[Negi1984]

Hi ,

Thank you Trixterz for your suggestion. I am attaching sample pic which value I need to copy to excel sheet. (Highlighted in Yellow).
Also if you could suggest any previous solution already available similiar to this ?
Thank you once again.

Also Is there any old