View original (French)

Excel to PDF conversion and hyperlink

Solved
ButteDuLac Posted messages 534 Status Member -  
cs_Le Pivert Posted messages 8437 Status Contributor -
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

  1.
    cs_Le Pivert Posted messages 8437 Status Contributor 730
     
    Try this to see:

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

    --
    @+ The Woodpecker
    0
    1. cs_Le Pivert Posted messages 8437 Status Contributor 730
       
      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 Posted messages 534 Status Member 41
       
      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 Posted messages 534 Status Member 41
       
      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 Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
       
      Hello,

      I tested 'save as...' in pdf.
      For me it works whether it's a link to a file or a URL.

      eric
      0