Reverse naming of file

[kenppy]

Hi,

I'm copying data relating to an engineered part into a sheet.
The format is constant and the name of the client and part appear in
specified cells. Is it possible now to rename the xls file as
(constant+ partname)? I mean automatically, not cutting and pasting.

thanks

 

[Luke M]

Via macro, you could do something like this (modify to suit)

Sub ReName()
xConstant = Range("A2")
xPartName = Range("B2")

ThisWorkbook.SaveAs xConstant & xPartName
End Sub

 

[kenppy]

thanks, does what it says.

(e-mail address removed) says...