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

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

--
Best Regards,

Luke M
"kenppy" wrote in message
om...
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

thanks, does what it says.

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