Cookie setting question....

The Gunslinger

Board Regular
Joined
Dec 28, 2003
Messages
76
I'm using a custom web browser in my stocks & shares Excel workbook, it opens to a specific page based on the shares currently entered in the main sheet, and displays any RNS releases for those shares, everything is working fine with one minor annoyance........ cookies

all the time i'm using it, at some point it throws this dam cookie popup warning, asking "if i'm a private investor" etc etc etc, it's actually f'ing annoying, because it even gets around the "i dont care about cookies" plugin i'm using in chrome! it then kills all navigation on the page, and forces interaction, and then fully reloads the page in the excel web browser which is just irritating and time consuming.

here's the site link
Code:
https://www2.trustnet.com/Investments/LatestAnnouncements.aspx

and here's what the warning looks like....




so what i'm looking to do is be able to inject a suitable replacement cookie at the opening of my web-browser, directly from vba and to suppress that annoying popup.

I have tried grabbing the cookie, it seems to set 2, and here's their content....


Code:
invtype
Investor
trustnet.com/
1088
2213047296
30707499
192506066
30634074
*
shortlisted

trustnet.com/
1088
2038912384
55423921
178945290
30634074
*
__cfduid
d26b53c0be80655f2948036b1776b8fb61512761019
trustnet.com/
9216
2243047296
30707499
183465549
30634074
*
TN_UserId

trustnet.com/
1088
59124736
30640109
192476064
30634074
*
_ga
GA1.2.307067057.1512761017
trustnet.com/
1088
4249338496
30780924
200806540
30634074
*
_gid
GA1.2.1807285346.1512761017
trustnet.com/
1088
908329600
30634275
200816541
30634074
*

Code:
invtype_client
Investor
www2.trustnet.com/
1088
2203047296
30707499
178835284
30634074
*
TN_Currency
GBP
www2.trustnet.com/
1024
3509037440
617110110
183475549
30634074
*
TN_TranslateLang
EN_UK
www2.trustnet.com/
1088
2048912384
55423921
192476064
30634074
*
TN_FundCurrency
GBP
www2.trustnet.com/
1088
2048912384
55423921
192756080
30634074
*
NewuserPopUp
1
www2.trustnet.com/
1088
2223047296
30707499
198546411
30634074
*
_ga
GA1.3.307067057.1512761017
www2.trustnet.com/
1088
4249338496
30780924
201096557
30634074
*
_gid
GA1.3.1807285346.1512761017
www2.trustnet.com/
1088
908329600
30634275
201096557
30634074
*

any thoughts or help appreciated.

It looks like it's dropping into the default IE cookie location....

\Users\******\AppData\Local\Microsoft\Windows\Temporary Internet Files
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

The Gunslinger

Board Regular
Joined
Dec 28, 2003
Messages
76
i'm still stuck on this one guys, if anyone could point me in the right direction it would be a start
 

Watch MrExcel Video

Forum statistics

Threads
1,127,165
Messages
5,623,115
Members
415,955
Latest member
ssheldon2021

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top