Save 1 workbook with individual sheets & formats.

hi there, please check attachment, the file was tested in Excel 2010

Thanks watersev for the script. But i ahve one issue with the attachment.

When i select NRP sheet and press save as excel then it is saving the active sheet but the selected sheet.

Once again i will repeat my request which i was requested above.

When i select a sheet from the list dispalyed in lsit box and press any button i.e. Save as PDF or Save as excel then it should save the selected sheet same place.

I hope you understand what i want.

Can we solve this issue please.

please check attachment

Thanks for your reply but there is another issue excel is working but same issue for pdf.

I have selected NRP sheet but is is saving active sheet with the nrp name.

what i means to say is, it is taking the name of selected sheet from the list but savng the active sheet. Could you please check the both options i.e. saving PDF and excel please.

Thanks for your time.

yes, sorry, I did not correct that in PDF code

Thanks a lot watersev. I works ofcourse it will work for original but i don't want to take any changes. I will get back to you tomarrow.

I am always thankful to you and for your valuable helpful script.

I have last and final request.

Sorry about this request because last night i remember that i have 2 languages of quotation. As a backup plan if my boss ask me to put this option as direct i.e. if a user generate the quotation then it should save as PDF or XLS then again i have to reffer this issue back to you.Can it be possible to have a script to save perticular sheet as xls. or pdf.

What i want here is i want to save a perticular sheet as PDF or XLs. So, please write a 2 scripts i.e. One is for PDF and another for XLS. So, that i can get a idea and i can change the script as per necessity.

For example i want to save quotation sheet as pdf or excel by clicking on button. NOT THE ACTIVE SHEET.

I hope you understand.

For more clarification please see the attachment.

SAVE perticular sheet as XLS & PDF.xls

I hope I understood you correct

You make my complicated request so easy. You are really genius. No words speak.

Thanks for your help. your script will save my daily heavy workload hours.

God bless you.

Thanks it works reputation will be added soon and topic marked as solved.