I had a look in your tips of the week and found this:
Public Sub SaveAsA1()
ThisFile = Range("A1").Value
ActiveWorkbook.SaveAs Filename:=ThisFile
End Sub
but this names the workbook and not the sheet. I suppose there is a code to name the 'sheet' also, possibly? does anyone know what it is or how to record the macro. thanks to anyone who has the answer. chiao
dj_dafad
This message was edited by dj_dafad on 2002-04-11 07:16
Public Sub SaveAsA1()
ThisFile = Range("A1").Value
ActiveWorkbook.SaveAs Filename:=ThisFile
End Sub
but this names the workbook and not the sheet. I suppose there is a code to name the 'sheet' also, possibly? does anyone know what it is or how to record the macro. thanks to anyone who has the answer. chiao
dj_dafad
This message was edited by dj_dafad on 2002-04-11 07:16