VBA code to save file using cell data

[tkroper]

Hi Friends!

I'm making my first attempt at VBA, trying to save a file using cell data to a file location. Here's what I have:

Private Sub CommandButton1_Click()Dim Path As String
Dim FileName1 As String
Dim FileName2 As String
Path = “H:\Audit Vendor Resources\Quality Review Checklist\Reviews\”
FileName1 = Range(“D10”)
FileName2 = Range(“D9”)
ActiveWorkbook.SaveAs Filename:=Path & FileName1 & “ ” & FileName2 & “.xls”, FileFormat:=xlNormal
End Sub

The "Path" is red and so is the "ActiveWorkbook.SaveAs" line. It says I have a syntax error. Can anyone help me correct this?

Thank you

 

[Domenic]

Instead of using the left and right quotation marks, use the regular double quotes. So, for example, the line assigning the path would be as follows...

Path = "H:\Audit Vendor Resources\Quality Review Checklist\Reviews\"

Hope this hleps!

 

[tkroper]

Yay! That worked! Thank you, Domenic

 

[Domenic]

You're very welcome!

Cheers!