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
Bookmarks