POST using MSXML2.ServerXMLHTTP60 used to work now ERROR

rick ales 6 Reputation points
2022-12-26T20:17:11.62+00:00

I am using MSXML object to POST data from an Excel worksheet to a REST API. My VBA macro used to work, now MSXML2.ServerXMLHTTP60 returns an MS error "No credentials were available in the client certificate." The POST request, URL, credential and body all work fine when testing with Postman but not with MSXML2.ServerXMLHTTP60 so the API owner tells me it is a problem with VBA. My VBA macro works fine with a commercial test site that does not require authentication. I found some help that was mostly gibberish to me that seemed to indicate an MS installation registry key had become corrupt???? MS Office Support was of ZERO Help.

  1. IS this a problem with MSXML2.ServerXMLHTTP60 or the API?
  2. What causes this error when using secret credentials with MSXML2.ServerXMLHTTP60?
  3. How to restore the previous functionality?
  4. Please explain step by step like I'm a 7 years old.

cheers,
Rick

Office Visual Basic for Applications
Office Visual Basic for Applications
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Visual Basic for Applications: An implementation of Visual Basic that is built into Microsoft products.
1,499 questions
{count} vote

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.