Excel to PDF conversion and hyperlink

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.

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.

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

Hello,

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

eric

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.

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