Not sure if this can be done. There are word files in a directory with all familiar names. i.e. fr001, fr002, fr003, etc... all with the extension .doc. I would like to know is there a code that will link an excel file to a directory and then be able to type the file name within a cell and it is automatically hyperlinked to that cell?
Divinedar
12
Newbie Poster
Recommended Answers
Jump to PostIn your Word document, do ctrl-F9. Within the braces that word gives you, type the following:
HYPERLINK "C:\\My Documents\\MyExcelFile.xls" So it looks like { HYPERLINK "C:\\My Documents\\MyExcelFile.xls" } But note that you can't type the { } braces by hand. You must use ctrl-F9 and type between …
All 4 Replies
AndreRet
526
Senior Poster
Divinedar
12
Newbie Poster
Divinedar
12
Newbie Poster
Divinedar
12
Newbie Poster
AndreRet
commented:
Well done in solving your problem. :)
+12
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.