Unlike XMLHttpRequest.status, this includes the entire text of the response message (' 200 OK', for example). Returns a DOMString containing the response string returned by the HTTP server. Returns an unsigned short with the status of the response of the request. Returns a Document containing the response to the request, or null if the request was unsuccessful, has not yet been sent, or cannot be parsed as XML or HTML. Returns the serialized URL of the response or the empty string if the URL is null. Is an enumerated value that defines the response type. Returns a DOMString that contains the response to the request as text, or null if the request was unsuccessful or has not yet been sent. Returns an ArrayBuffer, Blob, Document, JavaScript object, or a DOMString, depending on the value of XMLHttpRequest.responseType, that contains the response entity body. Just remember to change the code accordingly). Create the file called excelfile.xlsx on the C drive (or any other path. Open the VBA editor by using the Alt + F11 keyboard shortcut.
Returns an unsigned short, the state of the request. If you want to use the VBA code to open a workbook in read-only mode, you have to follow these steps. XMLHttpRequest.onreadystatechangeĪn Event handler that is called whenever the readyState attribute changes. This interface also inherits properties of XMLHttpRequestEventTarget and of EventTarget.
