Prompt for a filename when saving worksheet as csv file.

[mlski4751]

Hello, I am still learning VBA and am currently have my code saving My "VIP" sheet as a csv file in the "P:\Desktop\" location and giving it a specific name. I would like the program to continue to save it to the "P:\Desktop" location but prompt me for a filename. I have my current code below. Thank you for your help.

Please Login or Register  to view this content.

[danielexcelvba]

How about

Please Login or Register  to view this content.

[mlski4751]

That worked great. Once it is complete I currently get a message box that states the csv file has been saved to the desktop. How can I also get it to show the name of the file saved? do I input "CustomFileName"?

[code]
MsgBox ".csv file saved on your desktop."
[\code]

[danielexcelvba]

You could just change that line of code to

Please Login or Register  to view this content.

[mlski4751]

That did not work, the file name did not appear only .csv file saved on your desktop. Any thoughts? Thanks,

[danielexcelvba]

It will only work if

Please Login or Register  to view this content.

Is in the same Sub as

Please Login or Register  to view this content.

But if this is after you're already done saving, I would recommend using

Please Login or Register  to view this content.

[mlski4751]

Thank you that worked great. I appreciate your help.

[danielexcelvba]

You're welcome