Update Woocommerce order status with VBA code from Excel 2007

Job ID: 33652199

Budget: €30 – €250 EUR

I need a script that updates an Woocommerce order (above version 6.1), to a specified order status.

Input value to script are:
- URL to web shop
- username/key to API
- password/secret to API
- the order numer
- status code (Completed, Cancelled).

Retur value should tell if update was OK or not. No need for user interface.
Related categories: Visual Basic Excel WordPress WooCommerce Excel VBA