Go Back  Xtreme Visual Basic Talk > Legacy Visual Basic (VB 4/5/6) > VBA / Office Integration > Excel > improting data from web pages


Reply
 
Thread Tools Display Modes
  #1  
Old 09-01-2003, 03:54 AM
kanparaszt kanparaszt is offline
Newcomer
 
Join Date: Aug 2003
Posts: 3
Default improting data from web pages


Hi guys!

I'm writing a little application that opens a web page and gets data from them and then goes to another one. My problem is that the web pages are quite large and excel should wait until the whole document is opened. How can I make sure that the document is 100% opened (IE is ready) before I start processing?

Thank you for your help!
Reply With Quote
  #2  
Old 09-01-2003, 07:38 AM
herilane's Avatar
herilane herilane is offline
Unashamed geek

Retired Moderator
* Expert *
 
Join Date: Jul 2003
Location: London, England
Posts: 8,988
Default

I don't know how you're opening the web page, but if you're using xmlhttp.open, then using async=False will force Excel to wait until the request has been completed, for example like this:
Code:
XMLhttp.Open "POST", strURL, False
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Crystal Report Group Data breaking in two pages ashish908 Database and Reporting 0 08-27-2003 11:14 PM
Data Report print all pages laniek Database and Reporting 0 08-11-2003 08:09 AM
Copying data directly from web pages SMS Word, PowerPoint, Outlook, and Other Office Products 0 07-24-2003 08:25 PM
Dynamically printing pages using an Excel macro PrivatePile Word, PowerPoint, Outlook, and Other Office Products 1 06-12-2003 01:57 PM
programming for IRC with VB tutorial crazycheetah Tutors' Corner 0 05-04-2003 05:15 PM

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
 
 
-->