Copy link to clipboard
Copied
I am writing instructions for my colleagues, for how to get Excel to open some documents always at start of Excel.
How do I create a hyperlink to "C:\Users\%USERNAME%\AppData\Roaming\Microsoft\Excel\XLSTART", so that the hyperlink in the pdf that I make, opens the correct folder for each colleague?
Copy link to clipboard
Copied
Acrobat let’s you link to a relative or absolute file. It does not support environment variables or references to the user’s home directory. So, you can’t.
Copy link to clipboard
Copied
You can't link to a folder from within a PDF file. You can display the path to the user and have them open it manually, though.
Copy link to clipboard
Copied
Hi, This is Not True. You can make a hyperlink "Open File" and link it to any file, then open the pdf with wordpad and replace the hyperlink to direct to a folder. But my problem is the %USERNAME%, which will cause Internet Explorer to open, instead of the folder?
Copy link to clipboard
Copied
Yes, you can do that but it's an undocumented feature that is not likely to work on any environment and could cause your file to be flagged as potentially harmful. I would avoid using it.
Copy link to clipboard
Copied
Also, edit a PDF with Wordpad will leave it damaged and needing repair. Everyone who opens it will be prompted to save.
Copy link to clipboard
Copied
Ok, let's refrase the question.
How do I make a hyperlink in Acrobat for PERSONAL.XLSB, in folder XLStart so that the link works for any user?
When the file/folder is located with this address, which works from Start→Run for any user:
C:\Users\%USERNAME%\AppData\Roaming\Microsoft\Excel\XLSTART
Copy link to clipboard
Copied
Acrobat let’s you link to a relative or absolute file. It does not support environment variables or references to the user’s home directory. So, you can’t.
Get ready! An upgraded Adobe Community experience is coming in January.
Learn more