Reverse naming of file
 

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

Reverse naming of file
 

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

Reverse naming of file
 

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