Import Cookies from Chrome or Edge to Excel

Hello
I am doing web scrap using HTTP requests (Since IE retired):

I am able to accomplish everything, except the authentication.
My work around is authenticating manually with the browser (Chrome or Edge) and copy the cookies to Excel/VBA manually.

Chrome stores the cookies in a SQLite data base stored at:
%\AppData\Local\Google\Chrome\User Data\Default\Network

I have been attempting to import using the two folloing methods:

• VBA ADO "Microsoft ActiveX Data Objects"
• GET DATA -> From Other sources -> From ODBC

No success with either

Thanks
Victor

You could use SeleniumBasic. Example:

Please Login or Register  to view this content.

Hey Mogul

I have attempted with Selenium, but it gets blocked by my firewall. (No admin rights).
My IT department will not open exceptions.

I have atempted using UserForm with built in Web browser.
But, it uses IE and does not even load most websites.

Idealy Microsoft wouldve replaced all IE controls with Playwright.

I will continue to explore the GET DATA or the ADO alternative.

Thanks

I have used SQLite with Excel a long time ago but you need to install drivers. I would be surprised if Google does password protect and encrypt the database. It would be a security nightmare if they didn't.