how to pas parameters to JSON format data API to filter data

Question

i need to fetch data form JSON format web APIbut by filtering it can you suggest any way to pas those parameters (as eg . location) and retrieve filtered data from a public website (retrieving the data from portal totally legal an is for public use only)

Answer 1

We are opening the saved workbook which is an existing workbook.

The user will be going to save the excelworkbook and open the same workbook

so, when the saved workbook is reopened at that time we are using this workbook open event to perform respected operations

Answer 2

https://stackoverflow.com/questions/24692802/excel-vsto-workbook-open-event-not-firing