Hey everyone
I was wondering if someone could guide me to the proper resources or help me to come up with a macro for the following:
Cell 1 Cell 2 Cell 3 Hyperlinked Text (Word Doc) Full Text of Word Doc (Shrunk to Fit)
Basically I have columns of hyperlinks to word documents and in the adjacent column, I'd like to have the copied and pasted content of those documents in the adjacent column, shrunk to fit.
This would immensely help me because right now I am clicking the link, Ctrl+A, Ctrl+C the word document, closing the document, then Ctrl+V-ing each and every time.
I tried to record a macro (in excel) but it seems that the code doesn't recognize the select all/copy functions done in the word document. I've also created a shortcut macro (in Word) just to simplify the select all/copy functions under one shortcut but it doesn't save me enough time.
Thank you!!
Bookmarks