Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
Profil bruneta99
 | Femeie
25 ani
Satu Mare
cauta Barbat
25 - 50 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 739
|
|
This can be done with named destinations instead of pages.
IMPORTANT! Named destinations are not the same as Bookmarks.
This is especially for the case when you can edit the PDF file then upload it somewhere like OneDrive.
Having a link to a PDF file made by someone else, without access for you to modify, but with named destinations with a naming pattern can also work.
Without the naming pattern is almost the same as using pages and locations (there's another topic for that).
The disadvantages are:
- you need to edit the PDF file on your computer then upload it
or
- the PDF that you cannot edit must have named destinations with a naming pattern
The disadvantage of pages were:
- you have to refer to each page individually
- you have to refer to a location on the page, eg. up, down, middle
- you have to create 3 or 4 columns: one containing the page, one the location in the page, one with the link to the PDF file (but this can be embedded in the hyperlink if you have only 1 PDF) and one with the actual hyperlink to open the PDF file at the specified page and location (up, down, middle)
Named destination will just have:
- chapter number (which you might also add in the case of using pages)
- column with hyperlink to open the file
- additionally, if you have multiple PDFs you refer to, then you should also have a column with the link to the PDF files corresponding to each chapters (this is my situation)
The advantage is that if you set named destinations inside the PDF file and in Excel you only write some part of that named destination, then the following hyperlink formula would automatically get the named destination and open the PDF at the location of that destination, without the need of individual pages and locations besides the chapter name.
You must of course keep a pattern in naming your destinations, as you will see below.
In order to add named destinations, you have to be able to edit the PDF file with a free PDF viewer / editor, then upload somewhere like OneDrive. So if you send the Excel file, anyone who has access to it will also be able to open the PDF documents the Excel file relies on.
Named destinations can be created with some PDF programs, even with PDF-XChange Editor free:
- open the desired PDF file
- go to the desired paragraph / location in the PDF file
- go to to View - Panes - Destinations. This will open the destination pane on the left of the document.
- click on the New destination button (insert key on the keyboard) to add a destination at the current location in the PDF
- give it a desired name - I'd recommend something without spaces but anything would do
I named my locations in PDF as DRE14, DRE15 etc.
Chapter names are E1-4 and E1-5 and are stored in column B.
I have a column with the link to the PDF files, since I have more than 1 - column R.
In C2 my formula is as follows:
| =IF(B2<>"";HYPERLINK(R2&"#nameddest=DR"&SUBSTITUTE(B2;"-";"");"LNK");"") |
|
|
| pus acum 1 an |
|