Excel to csv?

[Mark M]

I know you can go to file>save as then select format but is there anything I could do so its basically a click of a button? MAcro perhaps? If so any pointers would be really helpfull!

I know it doesnt take that long to save as a csv but Im going to be doing it on potentially hundreds of files.

Thanks, Mark