Exporting Excel to Pdf with respective Sheet Names

[Paul Cherian]

Hi Experts!

I am trying to export my excel sheets to different excel workbooks with their respective names in PDF format with the help of following VBA Code. It works well when all the sheets are visible. On the other hand it wont work if any sheets are hidden. Could any expert fix it for me. I would like to select some sheets and export it. Hope i will get a nice advise at the earliest.

Please Login or Register  to view this content.

Thanks in Advance!!

[HangMan]

Hi Paul,

I'm no expert but you could simply unhide the hidden sheets before exporting them. Substitute the names of your hidden sheets in the Array where I've got "Green", "Blue". If you want to hide the sheets again after exporting then keep the 'Rehide Hidden Worksheets' code. If you don't mind them remaining visible then you can delete that part of the code. Are your sheets just Hidden or Very Hidden, if the latter replace xlSheetHidden with xlSheetVeryHidden if you do want to hide them again after exporting.

Please Login or Register  to view this content.

I hope that gives you what you need...

[Paul Cherian]

Dear HangMan,

Appreciate your effort and advise. But as it is an important workbook that contains more than 90 worksheets with specific project names it would not be easier for me to rename them with green or blue. Few sheets are hidden and some are very hidden too. I will look forward for more suggestions! Thanks again for your contribution.

Regards,

Paul Cherian.

[HangMan]

I wasn't suggesting renaming the worksheets, but substituting your actual worksheet names where I've used "Green", "Blue" in the sample... However, I'm sure someone will have a much simpler solution...

[Kenneth Hobson]

Please Login or Register  to view this content.

[Paul Cherian]

Dear Kenneth,

Thanks for your advise. However when I tried to run your modified codes, getting a Run time error 53 saying File Not Found. Could you please look in to this error!

Regards,

Paul Cherian.

[Kenneth Hobson]

Change = to <> in:

Please Login or Register  to view this content.

[Paul Cherian]

Thanks Kenneth...! Code is working! But it is exporting hidden worksheets also. Do you have any fix for this?

[Paul Cherian]

[Kenneth Hobson]

Please Login or Register  to view this content.

[Paul Cherian]

Oh My God !!! Perfect!!!! Thanks a Lot Dear Kenneth!!! :-) God Bless!