Macro to save each worksheet as a csv file.

  • I was given a workbook with many worksheets. I need to create a macro that will save all these worksheets as a separate csv file. Is that even possible. I would love a hit on how to even get started. Any suggestions would be great.


    Thanks

  • Re: Macro to save each worksheet as a csv file.


    See if this does it ...


  • Re: Macro to save each worksheet as a csv file.


    Fantastic.. This is awesome.. Works great.. I am just learning this and it's like trying to learn a foreign language..

  • Re: Macro to save each worksheet as a csv file.


    Great. Glad it worked for you.


    Yes, VBA is a language and sometimes it frustrates me as 'foreign' also.


    Good job!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!