Macro VBA

Closed
ka_8919 Posts 1 Registration date Wednesday February 6, 2019 Status Member Last seen February 6, 2019 - Feb 6, 2019 at 10:07 AM
 Blocked Profile - Feb 6, 2019 at 10:57 AM
I have a macro that saves my file to a specific folder. However, when I save the file it adds in text that should not be there

Sub Save_FileName_BillTO_ShipTO()
Dim Path As String
Dim filename As String
Path = "C:\Users\kyla.henry\Brown\Business Intelligence - Documents\Reports\02_Customers"

filename = " " & "December" & " " & Range("B2") & " " & Range(" A2") & " Monthly Usage BT ST"


ActiveWorkbook.SaveAs filename:=Path & filename & ".xlsx", FileFormat:=xlNormal
End Sub


For instance it will add 02_Customers to the file name. How do I get rid of that?

1 response

Blocked Profile
Feb 6, 2019 at 10:49 AM
Alter your path variable and remove the last forward slash on....
1
Blocked Profile
Feb 6, 2019 at 10:57 AM
Alter the variable path. It is coded in the variable.
0