A
Andy
Help Pleas
I have a problem with a macro that is saving a document. It works fine, but i want it to save the file firstly as the name it was opened under, "template.xlt", which is in the same folder as the target in the text below. This is so i can keepIs there an edit to the text below i can use to do this? The "I2" field is increased by one each time by another macro, and is used as an I.D number
Private Sub Worksheet_Change(ByVal Target As Range
If Not Application.Intersect(Target, Range("I2")) Is Nothing The
ThisWorkbook.SaveAs Filename:="C:\My Documents\UW Forms\" & Target.Value, FileFormat:=xlWorkbookNorma
End I
All help greatly appreciate
End Su
I have a problem with a macro that is saving a document. It works fine, but i want it to save the file firstly as the name it was opened under, "template.xlt", which is in the same folder as the target in the text below. This is so i can keepIs there an edit to the text below i can use to do this? The "I2" field is increased by one each time by another macro, and is used as an I.D number
Private Sub Worksheet_Change(ByVal Target As Range
If Not Application.Intersect(Target, Range("I2")) Is Nothing The
ThisWorkbook.SaveAs Filename:="C:\My Documents\UW Forms\" & Target.Value, FileFormat:=xlWorkbookNorma
End I
All help greatly appreciate
End Su