{Resolved}Problem with Word-Bookmark with VB.NET

[RobDog888]

Well, does the listbox get loaded from a datasource?

[dbelley_office]

The listbox yes.

But not the Date textbox. And that was only as example. On my true form there is 8-10 input fields.

[RobDog888]

Yes, then your better off with a word template document using bookmarks.
What happens if you close the document (in code) before the doc is done printing?
Maybe you could get rid of the loop?

[dbelley_office]

No I can't really get rid of the loop.

For my problem,

Using this code:

Do While objWord.BackgroundPrintingStatus > 0 
        ' needs Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) 
        Sleep (250) ' pause quarter second 
    Loop

Instead of this:

Do While objWord.BackgroundPrintingStatus > 0 
        Application.DoEvents() 
    Loop

Helps a lot for speed between document. Now it doesn't freeze.

But still ... I want this to happen in the background ... but I see a Word window showing for a very little while .. just very quickly flashing, but still I don't want that.

[RobDog888]

You could minimize Word in code so it wont flash.

Also, I was meaning what happens if you take out the loop completely? Does it error when your code try to close the document?

[dbelley_office]

See .. in the taskbar we see a Word window for like a quarter second. And my screen does as if it was too busy .. hard to refresh ..


I don't know if there is a way to avoid that.


The document doesn't print If I close it while it is in the queue.

[RobDog888]

Just before it prints set the Application.Visible = False and then when its done printing set it back to True.