Getting multiple cell data and passing into query on HTTP call

[SNA400]

HI All,

I'm hoping someone can help me with an idea on how to action the below.

We have a spreadsheet that contains Commodity Codes for goods being imported and we need it to take that code along with the country of origin and pass it into a HTTP call to get details back from the UK Trade Tariff.
I have some code that currently passes just a single cell data and recovers the description of the goods

and this works fine (with further code below) i getting the information.

I have been trying with the following changes but keep getting an error.

LookupURL = "https://www.trade-tariff.service.gov.uk/api/v2/quotas/search?goods_nomenclature_item_id=" & ActiveCell.Offset(0, 51).Value '&geographical_area_id=""& ActiveCell.Offset(0, 52).Value"

the code I need to pass to the LookupURL is, as an example, https://www.trade-tariff.service.go...re_item_id=7608208990&geographical_area_id=TR

I am falling down where i am trying to pass the second portion of the data - &geographical_area_id= - because the code will not accept the second set of quote marks, and it is getting frustrating.

I know this is possible and I know i'm barking up the wrong tree using quote marks but for the life of me I don't know what way to go.

Help!

Simon

 

[John_w]

Try:

    LookupURL = "https://www.trade-tariff.service.gov.uk/api/v2/quotas/search?goods_nomenclature_item_id=" & ActiveCell.Offset(0, 51).Value & "&geographical_area_id=" & ActiveCell.Offset(0, 52).Value

PS, please post code inside VBA tags, not as an image and then people can easily copy your code and help you.