Yahoo Answers is shutting down on 4 May 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
How to automate pdf creation from Excel?
I am trying to automate the creation of a set of financial statements monthly. I have multiple tabs in an excel file I want to print to a pdf. I use Adobe Acrobat X Pro.
If I use the "create pdf" feature from excel add in it gives me ability to select which tabs I wanted printed and reorder them. However I cannot determine how to save these settings. Once I close Excel I lose the tabs that have been selected and have to go thru the process again. How can I set up a routine that I can run again and again?
I am not looking for an excel macro solution. I can do that if I must but adobe must have a solution a well.
1 Answer
- 9 years agoFavourite answer
if you use office 2007 package you can find plug in save as PDF
first way click circle Microsoft icon that view at left top program and select save button with out clicl you can muse cruse over save and see other item on this list click other format and open web browser and download save as PDF .
