Saving multiple selected worksheets from a listbox as separate excel files

[dylanrose]

Hi all,

I found a code where in when selecting multiple worksheets in a listbox it will be saved as multiple pdf files. What I want to happen is that instead of saving it as pdf, it will be saved as multiple excel files and I want to save it depending on the path I put in Cell J5.

For example, I have a listbox containing Sheet1, Sheet2, Sheet3, Sheet4 and Sheet5.
If I select Sheet1 and Sheet2, the output will be 2 separated excel files containing their data.

The code that I found here: http://www.mrexcel.com/forum/excel-q...stbox-pdf.html is for saving multiple selected worksheets from a listbox as pdf.

Here's the code:

Please Login or Register  to view this content.

Thank you!

[bakerman2]

Please Login or Register  to view this content.

[dylanrose]

Please Login or Register  to view this content.

Hi bakerman2,

Just wondering, how can I change the relativepath? What if I want to select a folder first then save it?

Thank you for the quick reply! Will test your code.

[bakerman2]

Please Login or Register  to view this content.