troubleshooting Question

Opening Word Document Slow From VB Application

Avatar of jtrapat1
jtrapat1 asked on
Visual Basic Classic
11 Comments1 Solution577 ViewsLast Modified:
I'm using VB6 against an sql server database.

For some parts of the application, we launch a form which gives the user the ability to view a word document with comments about a particular document.
The time it takes for the word document to launch is very slow.
Is there anything specific that I could check or is there anything in my code that could be written differently to speed up the launching of the word instance?
Here's is the code:
------------------------------------------------------
Private Sub cmdOpenHighlights_Click()
    OpenWord
    Unload Me
    MyWord.Activate
End Sub
-----------------------------------------------------
Private Sub OpenWord()
    Set MyWord = New Application
    MyWord.Documents.Open FileName, , ReadOnly
    MyWord.Visible = True
    MyWord.Width = 600
    MyWord.Height = 440
    MyWord.Left = 0
    MyWord.Top = 0
End Sub
------------------------------------------------------
The word document is stored on a server and there are no problems with the server.
We simply pass the filename and its path on the server.

Thanks in Advance
John
ASKER CERTIFIED SOLUTION
eosu

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 11 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros