re : Save As

[ddiicc]

Hi there,
In my macros, I would like to have the script that will save the file as per
my request.

Path: D:/A Daily Yield/B Flex/VPB.csv

Can anyone help me on this code?

 

[JLGWhiz]

This worked on an Excel workbook:

Sub savAss()
ActiveWorkbook.SaveAs Filename:=InputBox("Enter Filename") & ".xls"
MsgBox ActiveWorkbook.Name
End Sub

You can change the .xls to suit your purposes.

 

[JLGWhiz]

If the path and file you posted is what you want to save as then the syntax is:

ActiveWorkbook.SaveAs Filename:="D:/A Daily Yield/B Flex/VPB.csv"

My previous posting assumed you wanted to save a file in the current
directory and path.