Honored Contributor
Re: Test case status change in test lab using Excel macros
Regarding question 2 - yes, this is correct. Using the API to connect to ALM does NOT open the UI.

Regarding question 1 - you need to find the test case that you want to update. What info do you have to identify the test case? You said you want to update the status in the Test Lab. Do you have the ID of the Test Instance? The name/ID of the Test Set that contains the Test Instance?

What info you have to identify the Test Instance dictates the methods you need to use ultimately to access it through the API and subsequently update it. It may help you to look at the API object that represents a Test Instance - namely the TSTest object. The API documentation provides lots of sample code for doing a variety of tasks. If you look at the API documentation, that might give you pointers.
[If this post solves or helps solve your issue, mark the thread as solved and give KUDOS to the author for their assistance.]

(Opinions expressed in my postings are mine alone, and do not reflect the opinions of my employer.No warranties express or implied for any solution/suggestion posted.)