help with macro
I'd guess that you have a hidden instance of MSWord running.
I'd reboot the pc and try the code one more time.
And I'd add:
wdApp.visible = true
right after the createobject line.
It might make testing easier.
Prohock wrote:
I am using the following macro in excel to open a specific word document that
the excel file merges records into.
Dim wdApp As Object
Dim wdDoc As Object
Set wdApp = CreateObject("Word.application")
Set wdDoc = wdApp.Documents.Open _
(Filename:="B:\test\test.doc")
The file loads in word but I get a message stating that the test.doc is read
only. I don't get the error message if I open the test.doc as per normal. How
can I change my macro so the document loads without being read only?
--
Dave Peterson
|