Reverse naming of file

  • Thread starter Thread starter kenppy
  • Start date Start date
K

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
 
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
 
Back
Top