View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Curt Curt is offline
external usenet poster
 
Posts: 469
Default error 5174 file could not be found

The file to open was sent to me as a rich text I saved it as a word.doc.
properties show this ok. Yet excel will not find file. Have both yearly &
yearlya in same folder (parade) It opens yearly fine but doesn't finf
yearlya? Copied yearly code then added a as needed. Following is my code. I
dont see what I did

Private Sub optionbutton35_Click()
OptionButton35.Value = False
Dim Word As New Word.Application
Dim WordDoc As Word.Document
Word.Visible = True
Set WordDoc = Word.Documents.Open("\parade\yearly.doc")
End Sub
-----------------------------
Private Sub optionbutton36_Click()
OptionButton36.Value = False
Dim Word As New Word.Application
Dim WordDoc As Word.Document
Word.Visible = True
Set WordDoc = Word.Documents.Open("\parade\yearlya.doc")
End Sub