How to save an excel as PDF with bookmarks

[ailatan]

Hi I am trying to save an excel file as PDF using vba, but all I can do is print as PDF, which takes the bookmars away. I need my PDF to keep the bookmarks, which are the sheet names in excel. I can manually do it if I go to save as>ADobe PDF, but is there a way to do this in vba? or a way to print as PDF and keeping the bookmarks?

-Thanks

 

[whitesabbathica9]

See http://forums.adobe.com/message/2253395#2253395

Hope this helps.