Excel to PDF conversion and hyperlink

Solved

ButteDuLac -

Hello,

The question has already been asked, but the answer does not meet my parameters.
I am using Excel 2010 and Nitro Pro 9. I cannot install conversion software myself (due to administrative restrictions). Therefore, I am using Nitro_PDF_Creator directly for the conversion.
Is there a way to convert my XLSX files to PDF while preserving my hyperlinks? It works perfectly from Word.
If anyone knows Nitro Pro, I would appreciate an answer, thank you!!!
I also tried with PDFCreator, without success.

Configuration: Windows 7 / Internet Explorer 11.0

4 answers

Answer 1 / 4
cs_Le Pivert Contributor
Try this to see:

https://forums.commentcamarche.net/forum/affich-31323754-bouton-enregistrer-sous#p31548893

--
@+ The Woodpecker
0
1. cs_Le Pivert Contributor
  
  To make it work, you need a folder named loto on the Desktop and put the name of the PDF file in cell A1 of Sheet 1.
  
  0
2. ButteDuLac Author
  
  Uh, that doesn't really meet my needs. I have many PDF documents in a folder on the network of our establishment, the hyperlinks lead to documents that are stored in the same place as my Excel file (on a network hard drive). I never save anything on the desktop. It's in a work context, so I can't give files silly names like "lotto." I know I could modify settings in the macro, but that's not really what I want. I found a temporary solution by keeping the file in Excel format and password-locking it so that people can view it and open the links without modifying, but it's not the most practical since I have to unlock it every time (with a password) to make my updates. I really need to save in PDF "with" the active hyperlinks, like is possible in Word.
  
  0
3. ButteDuLac Author
  
  I might try the macro on Monday, by changing the parameters, but since I'm not an expert in programming, I don't know what it will yield...
  
  0
4. eriiic Contributor
  
  Hello,
  
  I tested 'save as...' in pdf.
  For me it works whether it's a link to a file or a URL.
  
  eric
  
  0
Answer 2 / 4
cs_Le Pivert Contributor
This is an example to do with a new workbook with a hyperlink to see if it works!
Depending on the result, we will decide.
Have a good weekend!

--
See you! The Woodpecker
0
1. ButteDuLac Author
  
  Unfortunately, it doesn't seem to work.
  I created a lottery folder on the desktop. I inserted a Sheet 1, named a file in A1, then created a Save button, for which I pasted the suggested text. Nothing works. I'm getting an error (Option Explicit would be an unknown command). I tried removing it, but it doesn't change anything. I tried removing the other line that seemed to be conflicting (Sub), but it doesn't change anything. I saved my workbook to enable macros. Nothing helps. It doesn't work.
  
  0
Answer 3 / 4
cs_Le Pivert Contributor
Here is a template. The PDF will be created in the folder containing the workbook. Feel free to adapt it to your liking:

http://www.cjoint.com/data3/3BxsxA1c0C2.htm

--
@+ The Woodpecker
0
1. cs_Le Pivert Contributor
  
  Is there a way to convert my XLSX files to PDF while preserving my hyperlinks?
  
  I had forgotten the initial question
  
  Here is a new workbook with a hyperlink
  
  http://www.cjoint.com/data3/3BxsNZQp2nU.htm
  
  See you later, Le Pivert
  
  0
Answer 4 / 4
cs_Le Pivert Contributor
Hello,

since Excel 2007, you can save as PDF. The links work in the PDF.

--
See you later, Le Pivert
-2
1. ButteDuLac Author
  
  Thank you for the attempt! But I clearly wrote that I am using Excel 2010. And the links do not work. I know how to convert the file to PDF from the File/Save and Send menu, but no, the links are not working in my PDF. In fact, I see the link, but it is not clickable.
  I tried in the options, without success. Now, I am trying connecting to a network drive, just in case that could be it, but it's glitching, so I'm still in doubt!
  
  0

Excel to PDF conversion and hyperlink

4 answers

Uninstall doc pdf

Lost macbook backup password

Linkedin profile visits in private mode

Hp deskjet f4180 driver

Uninstall doc pdf

Instagram bug suspending accounts fixed

Continental edison tv outage

Reset my sleep mode output

All-in-one pc search

H3c - h3cne-rs+ & h3cne-pm