Sub SaveInvoiceWithNewName()
Dim NewFN As Variant ' Copy Invoice to a New Workbook ActiveSheet.Copy NewFN = "FILEPATH\" & Range("i5").Value & ".xlsx" ActiveWorkbook.SaveAs NewFN, FileFormat:=xlOpenXMLWorkbook ActiveWorkbook.Close NextInvoice End Sub
function copyDataWithinWorkbook() { var sourceSheetName = "Dashbord"; // Replace with the name of the source sheet var target...
No comments:
Post a Comment
THANKS FOR YOUR SUPPORT