Macro VBA [Closed]

Registration date
Wednesday February 6, 2019
Last seen
February 6, 2019
 Blocked Profile -
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 reply

Alter your path variable and remove the last forward slash on....
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Blocked Profile
Alter the variable path. It is coded in the variable.