Hi Guys
I have a problem with copying an Excel document to a different folder within Access, using the following code.
The code works if I move a .txt file, but I get a Run-time error 53, file not found when trying to move a .xlxs file.
Is there a special way for copying Excel files that I'm missing?
Regards
Louise
I have a problem with copying an Excel document to a different folder within Access, using the following code.
Code:
Private Sub btnMeasure_Click()
Dim Files
msCustomer = Me.fldCustomer
msJob = Me.fldJob
msMethod = Me.fldCastingMethod
msDate = Year(Date)
msDateFull = Format(Date, "yyyy-mm-dd")
FileStructure = "\\CMASERVER\Data\Louise\SLA\" & msCustomer & "\" & msDate & "\" & msDateFull & " - " & msJob & "\Measurement Report\" & msMethod & " Measurement Report.xlxs"
FileMove = "\\CMASERVER\Data\Louise\SLA\Report Masters\" & msMethod & " Measurement Report.xlxs"
FileCopy FileMove, FileStructure
End Sub
The code works if I move a .txt file, but I get a Run-time error 53, file not found when trying to move a .xlxs file.
Is there a special way for copying Excel files that I'm missing?
Regards
Louise
Last edited: