×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

problem with starting Word

problem with starting Word

problem with starting Word

(OP)
In the program that I am developping, in a form with a command button, every time the command button is activated a particular WORD file should be viewed.

I tried this with following program steps:

Set LV_WORD_App = CreateObject ("Word.Application")
LV_Word_App.Visible = True
Documents.Open "D:\60030508BOOM04.doc"

This works fine, but when I try to reopen the file with the same button, I get an error message 'automation error'. I tried to solve this problem by closing Word by adding the line

Set LV_Word_App = Nothing

But with no success.

Can anybody help me?

RE: problem with starting Word

There are two possibilities that immediately come to mind.  The first has to do with leaving documents open.  You show a Documents.Open but we have no indication of a corresponding Documents.Close before you Set LV_Word_App = Nothing.  That could leave an instance of Word hanging, thus not allowing for the creation of another instance.

There are also known problems when using unqualified references with automation objects.  In your sample code, you say 'Documents.Open' and I would suggest that you fully qualify that with 'LV_WORD_App.Documents.Open'.  Also, if you are using a 'With LV_WORD_App' construct, then you might try removing the With construct as that can also lead to hanging automation objects.

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login



News


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close