Not getting the values

M

Michael Grosse

Hi folks,
i haven't done excel programming for years but now i have to make a simple
excel add-in and getting mad.

My Code is:
Dim loginHttpRequest As XMLHTTP40
Set loginHttpRequest = New XMLHTTP40
loginHttpRequest.Open "GET", URL, True, LoginInfo.loginUid,
LoginInfo.loginPwd
loginHttpRequest.setRequestHeader "SOAPAction",
Configuration.MY_SOAPACTION
loginHttpRequest.setRequestHeader "MY_CALLER_APPLICATION_NAME",
Configuration.MY_CALLER_APPLICATION_NAME

loginHttpRequest.send

==> until here the code runs well...
MsgBox (loginHttpRequest.statusText)
==> This message box is empty although loginHttpRequest.statusText is
filled with a value

If i run this code in debug mode i get the value
If i run it without debugging the msgbox is skipped

If i try to get it into a String like tmp = loginHttpRequest.statusText, tmp
has as value "" after.

Has anyone had the same experience too and what did he do against it?

Thnx in advance

Michael
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Optionbutton Not working 3
VBA - exporting serial letters to single documents 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Finding the right style field in VBA 0
Finding the proper style field and the numbered paragraph value within the style 0
Autonumber field in Excel that behaves the same as Access 0
Menu Macro Not Executing - Need Help 1

Top