How to accept cookies using the "Get Data" function

[fatman42]

Hi everyone,

I'm in the process of building a PC and as some of you may know, there is a big shortage in computer components. This has caused prices to be sky high and finding a deal means trawling through websites for various parts.

As a result of this, I've decided to create an excel workbook that will record the current prices of various parts. I live in Ireland and there are no decent price comparison websites available here.

I'm trying to use the Get Data function on excel (receiving data from a web page) but I cannot understand how to get the request handler to accept cookies on websites before grabbing the data. Is there any way to do this?

Also if anyone knows any good links for information setting up this workbook of mine, please do share.

Kind regards,

Adam.

 

[Dan_W]

I don't often use the "Get Data" function in Excel, instead opting to use VBA to code any webscraping solutions. This would be doable in VBA, but of course would require learning VBA.

I may be wrong on this, but I suspect that you may only need to accept cookies once (the first time) - so if you can accept cookies manually the first time, I wonder if you could automate the data extraction from then on? If this did work, it would need to be done through (I think) Internet Explorer (Trident engine?).

Failing that, you may want to look into Power Automate Desktop. It's software developed by Microsoft that made available to users for free as of several months/a year ago. This software allows users to automate various task, including webscraping. It doesn't require any coding, either.

Just a thought.