Save All Worksheets As Individual Workbooks In a Special Folder in PDF format

I am trying to save all the worksheets as individual workbook in PDF format in a special folder with cell value. But it is giving me syntax error in below code. Can anyone help me to resolve this issue please.

Showing Error

Please Login or Register  to view this content.

Original Complete Code

Please Login or Register  to view this content.

Thanks for reply again i am getting an error.

Display Error:

Please Login or Register  to view this content.

I am attaching a sample file where Excel format is working fine but in the same way i need in PDF also.

I appreciate if you make necessary changes on the script posted in #1 because that scrip is making the folder where the file is running and caving the files base on cell value.

Your script is totally different from that script.

Hai Patel,

This code works perfect as per my requirement. I will test it on my original file and get back to you if i have any problem.

Hai Patel,

The script is showing error on my original file on

Please Login or Register  to view this content.

My original file have some hidden sheets might be this is the problem. Can you help me on this issue please. I need to convert only visible sheets into PDF.

Thanks it is working on my original file also. Topic marked as solved and reputation added.