saveas worksheets without renaming workbook

[val64]

Hello, Everyone,

I’m trying to export two of the five worksheets in my Excel workbook as csv files. I have the following code, which works a charm:

Please Login or Register  to view this content.

But once these lines of code have run, a couple of things go very wrong
* First, within my workbook, the two worksheets have been renamed as strFilenameYYY
* Second, my entire workbook has been renamed strFilenameYYY

How can I export the two worksheets without changing their names within the workbook and the name of the workbook itself?

Thanks!
Vincent

[royUK]

You can't apply saveas to the worksheet. You need to export it then save the new workbook usinhg saveas.

[royUK]

Try this

Please Login or Register  to view this content.

[val64]

Thank you. I love a solution that adds only two lines of code and modifies only two others -- and works! You've been a great help.