Excel to PDF conversion and hyperlink

Solved

ButteDuLac Posted messages 534 Status Member -
cs_Le Pivert Posted messages 8437 Status Contributor - 23 Feb 2015 at 18:31

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 Posted messages 8437 Status Contributor 730

Try this to see:

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

--
@+ The Woodpecker

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.

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.

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...

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

Answer 2 / 4

cs_Le Pivert Posted messages 8437 Status Contributor 730

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

ButteDuLac Posted messages 534 Status Member 41

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.

Answer 3 / 4

cs_Le Pivert Posted messages 8437 Status Contributor 730

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

cs_Le Pivert Posted messages 8437 Status Contributor 730

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

Answer 4 / 4

cs_Le Pivert Posted messages 8437 Status Contributor 730

Hello,

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

--
See you later, Le Pivert

ButteDuLac Posted messages 534 Status Member 41

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!

Excel to PDF conversion and hyperlink

4 answers

Car gps tracker

What is your experience with android tablets abor

Disable office

Comaps on play store

I would like to know how to report a scam

Reinstallation of w11 impossible after pc crash...

Site unreachable

Nonexistent sent items folder

Transfer mp3 from pc to mobile

Increase the capacity of free's zimbra webmail to 10gb