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
-Thanks