Print from Excel to PDF

Hi,

I have a workbook with 9 worksheets. One of the sheets contains a list (+/-200) of parameters. In another sheet i change with a macro a cell (x) which contains one of the parameterlist. I go trough the parameterlist with a macro.
Every time the cell (x) changes, i want to print this sheet to a pdf.
How do i do that?

tx
sonmicAsked:
Who is Participating?
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.

Ess KayEntrapenuerCommented:
install CUTEPDF (its free)

http://www.cutepdf.com/Products/CutePDF/writer.asp


open the sheet you want.

Hit PRINT

Instead of the printer, select CutePDF

It will save it as a PDF file instead
0
sonmicAuthor Commented:
Sorry, but i can't download software on that PC. I do not have administrator authority.
It must be done from excel
0
Jeffrey CoachmanMIS LiasonCommented:
Please click the "request attention"  link and ask that this Q be posted to the Excel Topic Area...
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

Ess KayEntrapenuerCommented:
You can't do it then

Even microsoft says you need 3rd party software
https://office.microsoft.com/en-us/excel-help/save-as-pdf-HA010064992.aspx

The only option is to use an online coverter

http://www.freepdfconvert.com/


hope that helps
0

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
Jeffrey CoachmanMIS LiasonCommented:
...or upgrade to Excel/Office 2007, where you just need an add in for this (an dd-in is not 3rd party software, it is more like an update)

...Or move up to Excel/Office 2010 or newer, were PDF conversion is included...
0
Ess KayEntrapenuerCommented:
he said he doesn't have admin, so he wont be able to install a new excel
0
Jeffrey CoachmanMIS LiasonCommented:
ok...
0
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 Access

From novice to tech pro — start learning today.