MSXML2.XMLHTTP clear excel cache/memory (?)
 

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

MSXML2.XMLHTTP clear excel cache/memory (?)
 

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

NickHK

"p3plyr" wrote in message
...
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

MSXML2.XMLHTTP clear excel cache/memory (?)
 

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!


"NickHK" wrote:

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

NickHK

"p3plyr" wrote in message
...
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

MSXML2.XMLHTTP clear excel cache/memory (?)
 

found a better link to log off with.