VBA Code:
Sub test()
Dim Loc As String
Dim out As String
'Dim path As String
'path = Sheets("Home").Range("H1")+ "\Temp.csv"
Loc = Sheets("Home").Range("H1") + "\Temp.csv"
out = "C:\Audit Reports\Compiled" + "\Final.pdf"
Call Shell("cmd /k C:\Users\example\Desktop\testa.bat " & " " & """" & Loc & """" & " " & """" & out, vbNormalNoFocus)
End Sub
This is what I mean: C:\Audit Reports\Compiled\Final.pdf= C:\Audit Reports\Compiled\06-02-2020.pdf
Thank you for the help and support.