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.
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: