Hoping you guys can help. I have an existing Open document where I will assign a macro to a button. I want that macro to open another file and save that file to a new name. Here's the code I have so far but it doesn't seem to work.
Code:
Sub Test()
Workbooks.Open Filename:=ThisWorkbook.Path & "\TEMPLATE.xlsm"
Dim varCellvalue As String
varCellvalue = Range("AM12").Value
Windows("TEMPLATE.xlsm").Activate
ActiveWorkbook.SaveAs = ThisWorkbook.Path & "\SAVED PROJECTS\" & varCellvalue & ".xlsm"
End Sub
! Use CODE TAGS !
Last edited by a moderator: