SonyaBlade44
Programmer
Hi,
I have a very long Excel document that contains links to external PDF documents. There are approximately 600 links, and when one is clicked, Adobe Acrobat Reader opens the cooresponding PDF file. Because there are so many, I don't have time to create each link in Acrobat. I would like to be able to make the Excel document a PDF, and have all the links created for me. I was surprised to find out that Adobe does not have any tool currently available to do this. Amazing.
I found a neat application suite (pdf995, pdfedit995), that will create PDFs and make links, but there is a problem with that. The automatic feature will only convert " or " text to links, and the manual function A) Would take me forever, and B) has no help for typing in the document link. I don't think I can enter the non-html path. In Excel, the link looks like this:
file:///\\cassie\proj\maps\bc\cachecreek\A3 115K.pdf
"cassie" is the domain, and my Excel file is located in the "maps" folder. I have several sub folders of maps, such as "alberta", "sask" etc.. and the PDF map files are in those folders.
Is there a way I can get my Excel document to PDF, preserving all the 600+ links to external PDF documents, contained within subfolders? Surely others must have come across this type of project.
Thanks in advance.
Cassandra Singer
I have a very long Excel document that contains links to external PDF documents. There are approximately 600 links, and when one is clicked, Adobe Acrobat Reader opens the cooresponding PDF file. Because there are so many, I don't have time to create each link in Acrobat. I would like to be able to make the Excel document a PDF, and have all the links created for me. I was surprised to find out that Adobe does not have any tool currently available to do this. Amazing.
I found a neat application suite (pdf995, pdfedit995), that will create PDFs and make links, but there is a problem with that. The automatic feature will only convert " or " text to links, and the manual function A) Would take me forever, and B) has no help for typing in the document link. I don't think I can enter the non-html path. In Excel, the link looks like this:
file:///\\cassie\proj\maps\bc\cachecreek\A3 115K.pdf
"cassie" is the domain, and my Excel file is located in the "maps" folder. I have several sub folders of maps, such as "alberta", "sask" etc.. and the PDF map files are in those folders.
Is there a way I can get my Excel document to PDF, preserving all the 600+ links to external PDF documents, contained within subfolders? Surely others must have come across this type of project.
Thanks in advance.
Cassandra Singer
