Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a Word macro that prints account data from our intranet
application using an InternetExplorer object. I wanted to print the account data for the accounts listed in my spreadsheet, so I copied the class into my spreadsheet. Internet Explorer seems to hang in my HttpPost sub -- specifically, I have a do doevents until readystate = readystatecomplete (whatever it is 4) and readystate is 1 indefinitely and then I have to end the Internet Explorer process forcefully. The HttpPost sub converts the postdata and calls Navigate, then waits for Busy and ReadyState to clear. Two strange (but typical I suppose) things: 1)this is the same code that works fine in Word and 2) it doesnt hang if I break at the top of the HttpPost routine and step through the code one line at a time. If anyone knows WTH is going on and how to fix it, let me know. I am thinking maybe I will try adding more .Busy and .ReadyState loops in there before the Navigate (although if I recall I one set of them already) or maybe some kind of timer delay. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find loop doesn't loop | Excel Discussion (Misc queries) | |||
Worksheet_Change - loop within a loop | Excel Programming | |||
need a loop | Excel Programming | |||
HELP!!!! Can't stop a loop (NOT an infinite loop) | Excel Programming | |||
For Each Loop | Excel Programming |