Hi there,
I have written a macro to copy a worksheet from an Excel spreadsheet into a new workbook. I then wish to save this wookbook as a CSV file.
The problem is that I want the Save As box to appear for the user, but I want to to default automatically to CSV in the file type drop down. The location and name of where the file is being saved depends on the user, the only constant is that the file must be CSV.
Can anyone help?
Thanks
Max
Bookmarks