Macro Help Needed

[Guest]

I am trying to put a control in a workbook where by I can save workbook to a
filename that is the contents of cell b1 and at the same time nominate a set
filepath
This is the code I am using without success.
Any help greatly appreciated.
Private Sub CommandButton4_Click()

Dim NewPath As String
Dim NewFileName As String

NewPath = "c:\Documents and Settings\Garry El\My Documents\WORK\JOB STATUS
REPORTS"

NewFileName = Range("b1").Value





End Sub

 

[Steve Easton]

I think you need an Excel group.