Read cookies from Chrome

[JasperD]

Hi all,

I am trying to find a way to read Chome cookies from my computer in VBA - I figured out how to get them from Firefox and IE, but have trouble getting them from Chrome (which is the commonly used browser in our company).
Does anyone know of a way to read the Chrome cookies from drive for a specific site?
Thanks!

[vba_php]

WHY? post the method you used to read them inside the FF and IE cache locs. if you do that, the process will be the same, literally, if you really did do that. a file is a file. sqlite is sqlite. cookies are cookies. xml is xml. hex is hex. etc, etc, etc....by the way, have you seen this tool?

http://inloop.github.io/sqlite-viewer/

[JasperD]

sure - IE:

Please Login or Register  to view this content.

Which you then access through 'cm("https://www.google.com")' (where cm is of course 'cookie monster' )

For FF I just read the cookies.sqlite file in %appdata%\mozilla\firefox\default.default using the sqliteforexcel method (which uses the winsqlite3.dll, standard in windows 10). Problem is that as far as a I know, Chrome cookies are encrypred, while FF are not.

[vba_php]

FF's cookies are NOT encrypted? I seriously doubt that. it depends on what you're reading. if you're reading login tokens/hashes, for instance, there is NO way that those would be unencrypted. but then again, those aren't stored locally anyway, or shouldn't be. in web DBs only.

not sure what to say here, but I can tell you that I already did the following. IE is available to me, however MS is forcing edge. thus, I got the image you see below. banks are blocking IE totally now. you can't use that same win DLL to read chrome I wouldn't think. why could you?

[JasperD]

Thanks for thinking along Adam, however, FF cookie values are perfectly readable while Chome cookies are stored encrypted in the sqlite file (C:\Users\username\AppData\Local\Google\Chrome\User Data\Default\cookies) - it makes sense for obvious reasons (and writing code to entice users to change their default browser to FF isn't the best approach), so I'll rethink how to handle this particular case.

[vba_php]

Sounds good. I will take a look and see if you're actually right about that about Chrome's cookie values, as you call it, not being encrypted. because like I said you can still store all sorts of stuff in a cookie file. and some of it obviously needs to be encrypted but some of it doesn't necessarily need to be because it's pretty much useless information to hackers.

[blackhat7]

hi................

[mogul]

Example using Selenium.

Please Login or Register  to view this content.

[Victor.Faria]

Hello

Was anyone able to solve this problem?

Since the Chrome stores cookies in a SQLite database, shouldnt we be able to access the database thru the "GET DATA"
Attachment 814800
I have attempted this, but no success.

Been trying to access with VBA ADO "Microsoft ActiveX Data Objects"
But it does not open the cookies file.

Its quite easy to do it in Python using

• cookiejar
• browser_cookie3

Thansk!

[FDibbins]

Hello

Was anyone able to solve this problem?

Since the Chrome stores cookies in a SQLite database, shouldnt we be able to access the database thru the "GET DATA"
Attachment 814800
I have attempted this, but no success.

Been trying to access with VBA ADO "Microsoft ActiveX Data Objects"
But it does not open the cookies file.

Its quite easy to do it in Python using

• cookiejar
• browser_cookie3

Thansk!

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

[Victor.Faria]

Hey Ford

I will start another thread.
But i am farly sure this thread is exacly what my query is about..

It seems the solution proposed was to use selenium.
I am working on a solution that does not require any add ins.