I have a Excel file that want to export/save as to .csv format. I have already create a custom button that is linked to my module. When the user click the custom button, then the current worksheet will be save copy as the indicated directory. It is no problem for me to create the custom button. But I dont know how to coding the "save copy as" part.
Public Sub SaveMyFile()
Once I click the button and then the file(.xls) is save copy as a "csv" file, however, there are lots of garbage in the file, it is not necessary for me. Has any another solution for me?