Hi I have looked everywhere for VBA code to open a Word Document based on a file path location and filename in a cell, then save and close it into another location, also entered into a cell.

I have come across this code, but unsure as to how to alter it to make it work the way i need it to :

Sub automateword()
Set wordapp = CreateObject("word.Application")
wordapp.documents.Open "C:\Users\DT168\Desktop\KTW\test.docx"
wordapp.Visible = True
End Sub

i want it to be able to reference the cell to get the file location.

And I have no idea how to make it then save it to a specific location, also from a cell file path reference.

For reference the opening file path would be in A1 and the saving file path would be in A2

Many thanks in advance