VBA workbook saveas to documents example please

[tynawg]

Hi,
Breaking the problem into small parts. I want to use VBA to save an copy of a workbook to a specific locations, documents on C drive as an example. The file name will be taken from the data in cells A1 and A2 for identification.
So first, save the file named from cell/s data. Then save as to documents.
I will post the next step as a separate question once this part is solved.
Any help much appreciated.

 

[DanteAmor]

For example:

Sub test()
  Dim sPath As String, sName As String
  sPath = "C:\books\"
  sName = Range("A1") & Range("A2")
  ActiveWorkbook.SaveCopyAs sPath & sName
End Sub

What do you mean with:
"Then save as to documents. "

 

[tynawg]

For example:

Sub test()
  Dim sPath As String, sName As String
  sPath = "C:\books\"
  sName = Range("A1") & Range("A2")
  ActiveWorkbook.SaveCopyAs sPath & sName
End Sub

What do you mean with:
"Then save as to documents. "

Hello and thank you for your time and help.
I suspect what I mean is where I want the new file saved to, i.e. save to documents, or desktop etc? I think you have it at sPath = "C:\books\" so perhaps It changes from books to documents?
Regards,
Wayne

 

[DanteAmor]

Just change that line to the name of the folder where you want to save the files.