View Single Post
 
Old 10-17-2019, 12:23 PM
Jazz43 Jazz43 is offline Windows 10 Office 2016
Advanced Beginner
 
Join Date: Oct 2009
Posts: 54
Jazz43 is on a distinguished road
Default Extract Path in quotes and insert it into text

Hi,
Is there a way to extract a part of text from a line and insert it as a hyperlink on the "name of pdf" on that's line with macros?

I made a batch file to export a list of path and his filenames but it can't create hyperlinks inside a .txt file

In theory i know how can i did it.
But in practice, i don't know to much about vba.
I would really grateful if someone could help me, because the list has approximately 800 files.
So beforehand thanks.

Example:

With this:

Ars Combinatoria, Bruno, Llull - General Memory Chat - Art of Memory Forum.pdf "C:\Users\Admin\DOCUME~1\Inks\Ars Combinatoria, Bruno, Llull - General Memory Chat - Art of Memory Forum.pdf.lnk"
Only Few days left for exams - Homework, Test, and Study Help - Art of Memory Forum.pdf "C:\Users\Admin\DOCUME~1\Inks\Only Few days left for exams - Homework, Test, and Study Help - Art of Memory Forum.pdf.lnk"
https___forum_artofmemory_com_t_bitacora-memory-chronicle-11_26217.pdf "C:\Users\Admin\DOCUME~1\Inks\https___forum_artofm emory_com_t_bitacora-memory-chronicle-11_26217.pdf.lnk"
artofmemory_com_wiki_How_to_Build_a_Memory_Palace. pdf "C:\Users\Admin\DOCUME~1\Inks\artofmemory_com_wiki _How_to_Build_a_Memory_Palace.pdf.lnk"

I'll hope do this:

Ars Combinatoria, Bruno, Llull - General Memory Chat - Art of Memory Forum.pdf
Only Few days left for exams - Homework, Test, and Study Help - Art of Memory Forum.pdf
https___forum_artofmemory_com_t_bitacora-memory-chronicle-11_26217.pdf
artofmemory_com_wiki_How_to_Build_a_Memory_Palace. pdf

Last edited by Jazz43; 10-17-2019 at 12:38 PM. Reason: I add a line break
Reply With Quote