G
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
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