Thanks for the reply but I AM supplying the full file name and I am NOT supplying the name "RAN2_101bis_Sanya." The code posted is only a small section of the code that does the opening of the file. If you download the file from the link above and try to open it in VBA, you will see exactly what I am talking about. Here is a subroutine that you can use to replicate exactly what I am talking about for yourself:
Sub Test()
Dim doc As String
With Application.FileDialog(msoFileDialogFilePicker)
.AllowMultiSelect = False
.Filters.Add "Doc Files", "*.docx; *.doc", 1
.Show
If .SelectedItems.Count = 1 Then
doc = .SelectedItems.Item(1)
Else
End
End If
End With
Dim wdApp As Word.Application
Set wdApp = Nothing
Set wdApp = Application ' New Word.Application
wdApp.Visible = True
Dim wd As Word.Document
Set wd = wdApp.Documents.Open(doc)
End Sub
BTW, it is only this file and files like this one that have an issue. Other files open fine. This file uses sharepoint security in some way but what is odd is that the file opens fine using Windows Explorer double click.