VBA - open word doc

[george hart]

I'm trying to open an existing word doc where I then need to copy and paste data from an Excel file.

When running the code below I keep getting a message saying it's in use and goving my the option to open as read only etc?? Any idea how I can stop this??

Set wordapp = CreateObject("word.Application")

wordapp.Documents.Open "C:\Documents and Settings\HartG\My Documents\Dave Slater\HSS Fleet Report 0500.doc"

wordapp.Visible = True

End Sub

 

[Jaafar Tribak]

I'm trying to open an existing word doc where I then need to copy and paste data from an Excel file.

When running the code below I keep getting a message saying it's in use and goving my the option to open as read only etc?? Any idea how I can stop this??

Set wordapp = CreateObject("word.Application")

wordapp.Documents.Open "C:\Documents and Settings\HartG\My Documents\Dave Slater\HSS Fleet Report 0500.doc"

wordapp.Visible = True

End Sub

That error is telling you that the document is already open. Maybe you it is open inside a hidden Word instance.

Try bringing up the task manager ( Ctl+Alt+Del keys ) and see if there is a another hidden word application running and if so terminate its process and run your code again.