File format is not valid - opening word file by vba

[matsuchika]

Hello, could you help me ?

Below code slows me an error that the file typs is not valid. Basically the first link has January file, second has Feburary file, and tyring to copy January file into February folder. I can open the January file by copying in the link in the (i,7) cell value.

======

Sub CopyWordFiles()

For i = 24 To 61

LastMonthFile = Application.Workbooks("Macro Master File.xlsm").Worksheets("CreateWordFile").Cells(i, 7).Value
ThisMonthFile = Application.Workbooks("Macro Master File.xlsm").Worksheets("CreateWordFile").Cells(i, 8).Value

Workbooks.Open Filename:=LastMonthFile, ReadOnly:=True

ActiveWorkbook.SaveAs Filename:=ThisMonthFile


Next i

End Sub