Exporting Multiple Worksheets as CSV

[JPSIMMON]

So I am using this code to export as PDF to a certain location for a bunch of worksheets. Am I able to use this same sort of line, but to export as csv? How would I do so?

Please Login or Register  to view this content.

[Alf]

Something like this perhaps?

Please Login or Register  to view this content.

Alf

[JPSIMMON]

Wow that was quick. Works great.
How do I get this to name the csv the same as it's worksheet name?

Thanks again,

[Alf]

Replace "Book" with Sheets(i).Name i.e.

Please Login or Register  to view this content.

If this solves your problem don't forget to mark you thread "Solved"

Alf

To mark your thread solved do the following:
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved

[JPSIMMON]

It's sending the CSV's named sheet1, sheet2, sheet3.
How can I have this export the sheet name or where do I list the sheet name in the code?

Thanks,

[Alf]

This should do it then

Please Login or Register  to view this content.

Alf