VBA to save each page in excel as PDF with Certain File Name

[dabbott]

Is there a VBA code in which i can have an excel sheet with 20 pages, to have each of the 20 pages saved in a certain folder (C:/My Work) as PDF with certain file names? I have 20 pages of locations and i need each location to be saved as a PDF with the city's name as the file name. Like Denver as Denver.pdf right now i have having to manually type in each name and this is a process i repeat many times everytime someone has me change any data. Thanks.

 

[dabbott]

Thanks i got it to work in a different folder.

 

[dabbott]

Is there a limit to the number of worksheets that this will work with? i got it to work find when i had 2 worksheets. However when i added another 30 worksheets it did not work.