Skip to main content
kevinb44915509
kevinb44915509
Participant
April 16, 2016
Question

Best Practices Request: Adobe Acrobat XI Pro and Consolidating Spreadsheets into PDF reports

  • April 16, 2016
  • 2 replies
  • 393 views

Hello,

I work in finance and my department consolidates many different Excel spreadsheets into PDF packages every quarter.  We have written some macros, which make the production of reports in our department easier, but we also receive spreadsheets from other departments to include in our packages. 

Some of our packages are 50 to 60 pages long and we usually get information at 3PM and need to produce these packages by 5PM for the next business day.  In addition, people typically run rate or have last minute changes that absolutely need to get in.  There is definitely some process improvement there regarding working practices, but from a tech perspective, are there any tips available

Right now we use the combine multiple files function for consolidation, but sometimes these jobs take a bit of time for the 60-page packages.  I feel like this is a pretty common practice in Finance.

This topic has been closed for replies.

2 replies

try67
Community Expert
try67Community Expert
Community Expert
April 18, 2016

It can be done using an Action, but I don't think you'll be able to select which worksheets to convert doing it like that.

try67
Community Expert
try67Community Expert
Community Expert
April 17, 2016

It's not really clear what kind of advice you're looking for... If you need to combine multiple files as a single PDF then the Combine Files command is the best and probably only way of doing it. You can always ask people to hand in PDF files (assuming they have Acrobat) instead of the Excel files. Then you'll just have to merge those PDFs to a single file, which is much faster then merging other formats, but it's still pretty much the same process.

kevinb44915509
kevinb44915509Author
Participant
April 18, 2016

Hello,

Is there a way to create PDF's from multiple files without having to open up individual Excel worksheets and saving as a PDF?  Typically we are opening files and only converting certain selected worksheets.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices