hyperlinks

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Hyperlinks

Hyperlinks

resolvedResolved · High Priority · Version 2003

Gareth has attended:
Excel VBA Intro Intermediate course
Excel Intermediate course
Excel Advanced course

Hyperlinks

Hey

Im trying to link from excel to a specific word document that looks up the text value of one cell and searches and finds the exact document in another folder.

For example in column AF I have a number like '56TD67890'.

On the company server I also have a word document that goes by the same name. Im trying to create a hyperlink to the server that takes me directly to the word document that matches the text value in column AF.

Is this possible?

Thanks

RE: Hyperlinks

Hi Gareth

Not sure about this one myself, I'll ask one of my colleagues to have a look at this for you tomorrow.

Kind regards
Amanda

RE: Hyperlinks

I have tried combining the concatenate function with the hyperlink but it doesn't work. Any advance on if this is possible?

Thanks in advance.

RE: Hyperlinks

Hi Gareth

I apologise for the delay in replying. I have been away from work for the last few weeks due to illness.

I realise that you may have already solved the problem, if this is not the case could you please advise me so that I can giver it my urgent attention

Regards

Stephen

Mon 27 Jul 2009: Automatically marked as resolved.


 

Excel tip:

Closing Multiple Open Worksheets At Once

When multiple Excel worksheets are opening, rather than performing a File > Close menu option multiple times, hold down the the SHIFT key and select the File > Close All menu option.

Close All menu option is only displayed when Shift key is down

View all Excel hints and tips


Server loaded in 0.09 secs.