Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Not getting the values
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exclude #N/A values and Return Numeric values to consecutive cells in Single Row | Excel Worksheet Functions | |||
Why does this code remove Duplicate Values, by showing only 1, but it does NOT show Unique values for some reason ? | Excel Programming | |||
Search/Filter to find values in another range based on two cell values | Excel Programming | |||
How do I search thr'o column and put unique values in differnt sheet and sum corresponding values in | Excel Programming | |||
Predict Y-values on new X-values based on other actual X and Y values? | Excel Programming |