Dynamically creating a link to another document within excel

P

Paul Moore

Hello,

I was wondering if it is possible to dynamically create a link to a new
document from within Excel. I was hoping to:
- open the other application (OneNote), fill in the document, and then close
the document
- create a link in a specific cell such that double-clicking on that cell
re-opens the document

Can this be done? I suppose macros are the order of the day?

Many thanks,
Paul (macro impaired)
 
Top