Save Microsoft Excel sheets to separate CSV files

1143015 pts.
Tags:
CSV file
Microsoft Excel
Is there a way for me save each Microsoft Excel sheet in my workbook to separate CSV files with a macro? I know Excel won't let me save all the sheets to different CSV files so I thought there might be another way. Thanks.
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    What language are you looking at for your macro?
    132,840 pointsBadges:
    report
  • ToddN2000
    I thought there was an option where you can save the sheets individually. Just do a save as and select "worksheet"  instead of "workbook".. What version of Excel are you using ?
    132,840 pointsBadges:
    report
  • carlosdl
    You could use the Excel.Worksheet's SaveAs function.

    You would just need to loop through the ThisWorkbook Worksheets collection.
    84,745 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: