Macro VBA [Closed]

Report
Posts
1
Registration date
Wednesday February 6, 2019
Status
Member
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....
1
Thank you

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

CCM 4650 users have said thank you to us this month

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