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!