I have the following code in a worksheet I am using to raise purchase orders. The worksheet is called Purchase Order.xlt
Sub auto_open()
NewOrderNumber
RenameFile
End Sub
Private Sub NewOrderNumber()
Range("ref").Copy
Range("ref2").PasteSpecial Paste:=xlValues, _
Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
ActiveWorkbook.Save
End Sub
Private Sub RenameFile()
Dim myOrderNumber As Range
Set myOrderNumber = Range("OrderNumber")
ActiveWorkbook.SaveAs
("R:\............\Purchase Order " & myOrderNumber & ".xls")
End Sub
This works fine as its creating a new file for each order, the problem I have is when I reopen the order for review - it renames it!
I need something that says 'if I've already been numbered don't do it again' or probably more simplistically something like "If I am called *.xlt then rename me, but if I am called *.xls then don't"
Can someone help me with this.
Many thanks
Sub auto_open()
NewOrderNumber
RenameFile
End Sub
Private Sub NewOrderNumber()
Range("ref").Copy
Range("ref2").PasteSpecial Paste:=xlValues, _
Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
ActiveWorkbook.Save
End Sub
Private Sub RenameFile()
Dim myOrderNumber As Range
Set myOrderNumber = Range("OrderNumber")
ActiveWorkbook.SaveAs
("R:\............\Purchase Order " & myOrderNumber & ".xls")
End Sub
This works fine as its creating a new file for each order, the problem I have is when I reopen the order for review - it renames it!
I need something that says 'if I've already been numbered don't do it again' or probably more simplistically something like "If I am called *.xlt then rename me, but if I am called *.xls then don't"
Can someone help me with this.
Many thanks