On a form, I have a command button with the following code inserted on the Click event:
Private Sub Command1_Click()
Dim wordapp As New Word.Application
wordapp.Visible = True
Set wordapp = Nothing
When you click the button for the first time, it opens up Microsoft Word. However, if you do not close Word and click the button again, you get a VB runtime error (Automation error). What you really want to happen is another instance of Word to open up.
It seems the problem is to do with trying to start another Winword.exe process, but I can't work out how to solve it.
That's the question, I hope someone can help.