Change of page orientation from excel to pdf

I am trying to automate converting multiple excel files into pdfs for everyday presentations. There are a couple graphs i have which are in landscape mode. So the problem is some graphs still appear to be in the landscape mode (as i want them) but some which are originally set in landscape mode in excel show as portrait in pdf. What should i do to fix this issue. I know i can use adobe acrobat to do this but i am looking for a free software.
sdagaAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rob HensonFinance AnalystCommented:
Not sure I understand your issue.

Portrait or Landscape is the page orientation not a graph setting.

If a graph is wider than it is tall then it looks like it is in Landscape orientation but if you then print it to pdf on a portrait page it should just shrink to fit the page width rather than rotating to fit better on the page.

Thanks
Rob H
sdagaAuthor Commented:
some graphs just come in landscape but some change there orientation in the portrait mode. So the graphs are shown fully but i have to turn my head to see them. If you still don't understand the issue please let me know.
Rob HensonFinance AnalystCommented:
Are the graphs on proper chart tabs in Excel or within a data sheet?
Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

sdagaAuthor Commented:
It is on a chart sheet.
Rob HensonFinance AnalystCommented:
What are the page layout settings on that Chart Sheet?
sdagaAuthor Commented:
orientation is landscape.
sdagaAuthor Commented:
When i manually try to save the file as PDF File->save as, it works fine.
Rob HensonFinance AnalystCommented:
And what are you doing when its not working fine?
sdagaAuthor Commented:
Thats what i am trying to figure out.
Paul SauvéRetiredCommented:
You can use this free software to rotate the necessary pages: PDFill PDF Tools

PDFill PDF Tools are FREE PDF functions to merge, split, reorder, delete, encrypt, decrypt, rotate, crop and reformat PDF pages,  to add information, header, footer and watermark, to convert images to PDF, PDF to images or PostScript to PDF, to delete, flatten and list form fields, to scan to pdf, to create transparent image, and more.

No watermarks! No pop-up ads! FREE for personal or commercial use! FREE distribution!

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sdagaAuthor Commented:
This will do it for the current file. But i am automating the conversion from excel to pdf. So by using this everytime i would have to change the orientation.
sdagaAuthor Commented:
is there any script that merges all pdfs and changes specific page orientation?
Paul SauvéRetiredCommented:
is there any script that merges all pdfs and changes specific page orientation?

Not that I know of! You would have to detect the rotated pages programmatically & this seems rather difficult to me!
Rob HensonFinance AnalystCommented:
I think I now understand your comment from last week.

When you do the task manually it works fine but when you try to automate it with VBA it doesn't work. Is that correct??

Thanks
Rob H
sdagaAuthor Commented:
That is correct. It is because when i do it manually, only the current file is saved. When automated, it takes the original formatting.
Rob HensonFinance AnalystCommented:
Can you upload the script that you are currently using?

I suspect it will need some means of resetting between files; I can't guarantee that I will be able to make the required tweak but there are others on here that will be able to.

Thanks
Rob H
sdagaAuthor Commented:
I have attached a sample of the file i am using.
Rob HensonFinance AnalystCommented:
Oh no you haven't!!

Is it panto season yet?
sdagaAuthor Commented:
Rob HensonFinance AnalystCommented:
What is that? Its not an Excel VBA routine.
sdagaAuthor Commented:
so currently when i am converting the files from excel to pdf, the orientation is correct. But when i am combining the pdf files, some orientations remain the same while some change to portrait.

I use this SampleMergePDFs.txt as a bat file.
Rob HensonFinance AnalystCommented:
Sorry not familiar with Bullzip Merge PDF so I will have to withdraw. Hope you get it sorted by one of the other experts.

Apologies,
Rob H
sdagaAuthor Commented:
I am not specific on using Bullzip. If there is any other script that you recommend would rectify, you are more than welcome.
Rob HensonFinance AnalystCommented:
Try recording the routine when running manually in Excel.
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.