ChrisOswald
Active Member
- Joined
- Jan 19, 2010
- Messages
- 454
I have a userform that's a bit... busy. There's a word document that's been written that describes how to use this form. Using this code:
opens the document read only. However, when I close it, I get an alert popup saying:
This file is in use by another application or user. (C:\...\Templates\Normal.dotm)
with a show help>> button under it.
Clicking ok gives me a Save As dialogue for Normal.dotm, which won't let me save, and then a bunch of other boxes basically going through the same rigamarole.
It works fine in 2003, but on the 2 2007 machines I've tested it on I get the above goofiness. Any ideas?
Code:
Private Sub cmdHelp_Click()
CreateObject("word.Application").Documents _
.Open("C:\Documents and Settings\oswalcj\My Documents\Outreach Tool Maintenance Instructions.docx", _
ReadOnly:=True) _
.Application.Visible = True
End Sub
This file is in use by another application or user. (C:\...\Templates\Normal.dotm)
with a show help>> button under it.
Clicking ok gives me a Save As dialogue for Normal.dotm, which won't let me save, and then a bunch of other boxes basically going through the same rigamarole.
It works fine in 2003, but on the 2 2007 machines I've tested it on I get the above goofiness. Any ideas?