Hi
i am trying to create a macro that will automatically save a sheet as a CSV sheet with the filename as a concatenated cell name within another sheet if that makes sense.
this is what i have so far.
sfilename = Sheets("dealer input").Range("i1").Value
Sheets("CSV").Select.SaveAs Filename:= _
"X:\Applications\1-Inbound\sfilename.csv", FileFormat:=xlCSV, _
CreateBackup:=False
End Sub
but all this is doing is saving the file as sfilename
any help will be greatly appreciated
thanks
i am trying to create a macro that will automatically save a sheet as a CSV sheet with the filename as a concatenated cell name within another sheet if that makes sense.
this is what i have so far.
sfilename = Sheets("dealer input").Range("i1").Value
Sheets("CSV").Select.SaveAs Filename:= _
"X:\Applications\1-Inbound\sfilename.csv", FileFormat:=xlCSV, _
CreateBackup:=False
End Sub
but all this is doing is saving the file as sfilename
any help will be greatly appreciated
thanks