LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default VBA InternetExplorer ReadyState loop

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find loop doesn't loop JSnow Excel Discussion (Misc queries) 2 June 24th 09 08:28 PM
Worksheet_Change - loop within a loop bgm Excel Programming 1 January 19th 04 01:27 PM
need a loop DENISE Excel Programming 2 January 9th 04 07:58 AM
HELP!!!! Can't stop a loop (NOT an infinite loop) TBA[_2_] Excel Programming 3 December 14th 03 03:33 PM
For Each Loop Matt[_21_] Excel Programming 3 November 2nd 03 09:14 AM


All times are GMT +1. The time now is 10:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"