VBA: Save as CSV, no prompts, close file. Excel 2007
Posted on 2013-06-14
I have scoured the web and can't find definitive code for this. They all have variables I don't know how to alter.
I simply want to save the XLS file to a CSV file right in the same folder, with the same name, and then close it. I don't want to be prompted about anything. I even know how to do that part, but not how to just save it. I'm not going to paste partial code because I don't know of any that is absolutely correct.
I don't need any error handling or anything. It's just for my personal use.
Thanks so much!