Update Airtable fields using Excel VBA

I want to update my Airtable fields using Excel VBA. Thus, I went through the Airtable API documentation. But there is no way I could figure out to use PATCH method inside the VBA. Is there any resource available on the internet to achieve the result?

NB. I don’t want to use any third party apps as I need to update the whole sheet twice a day and there are more than 10k fields.