Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Waiting for Document to load

0 views
Skip to first unread message

C_P

unread,
May 22, 2006, 2:09:01 PM5/22/06
to
am creating a word document that basically analyzes other word
documents that contain UAT test resuts (versus putting a button and
code on hundereds of documents). This should be done in VB.NET or
something along those lines, but licensing is an issue. My problem
lies when a document is opened up that takes a bit to load but the code

does not wait and executes before it is finished loading, giving
completely bogus results.
Here is the run down:

User selects which file to analyze using a dialog box, which
unfortunately does nothing else:


Application.Dialogs(wdDialogFileOpen).Show


<document starts to load>


<"freezes" document loading and executes code, giving bogus data>


<document finishes loading>


<user gets confused>


I would like a way to wait for the document to finish loading before
the analyzing code is executed.

I have tried using DoEvents in a for loop, such as:

For i = 1 to 50
DoEvents
Next i

but since the CPU is generally doing nothing, it has virtually no
affect.
....

Thanks!

Jezebel

unread,
May 22, 2006, 5:52:03 PM5/22/06
to
Don't know how VB.Net does this, but in ordinary VBA it's like this --

Dim pDoc as Word.Document

Set pDoc = Documents.Open(FileName:=....)
---> this instruction isn't executed until pDoc is opened ...


"C_P" <Camer...@gmail.com> wrote in message
news:1148321341....@j33g2000cwa.googlegroups.com...

0 new messages