MSXML2.XMLHTTP clear excel cache/memory (?)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi

after successfully logging in and getting the data i need, employing the
MSXML2.XMLHTTP post method, once the sub ends, and i try to run the sub
again, it acts as if i am still logged in - or something like that - and bugs
out. however, if i exit excel and restart the sub works great.

so somehow excel is 'holding' onto somethin and i want to 'break' the
connection to the site, so to speak, without having to exit and restart excel
all the time.

any ideas?

many thanks in advance
 
I would guess you are not closing all object and setting to nothing.
Depends on the scope of your variables.

NickHK
 
there is only one object (named objHTTP)
i have several DIM strings
a few loops
and a for if

i tried Set objHTTP = nothing

but still tied up

i even tried posting a log off at the site but excel would not let me go

i have not tried 'closing' the object. not sure how to do that yet.

i tried

objHTTP.Close

but it bugs out "object doesnt support this property or method"

any ideas?

thanks for the reply!
 
Back
Top