madforgolf
Board Regular
- Joined
- Oct 20, 2006
- Messages
- 182
- Office Version
- 365
- 2016
Hi Folks,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Is it possible to create a macro or code for the following issue?
<o> </o>
In column B I have a list of names (which could build to 500) that I aim to hyperlink each to their own word doc file. When adding a new name, can a macro run to check down the list to see if a hyperlink is made, if not add the link to a word doc using the same title as the cell in another folder. Thus it has to create the word file before it can be linked?
<o> </o>
I have a button that will put the names in alpha order.
<o> </o>
Cheers
Marty
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Is it possible to create a macro or code for the following issue?
<o> </o>
In column B I have a list of names (which could build to 500) that I aim to hyperlink each to their own word doc file. When adding a new name, can a macro run to check down the list to see if a hyperlink is made, if not add the link to a word doc using the same title as the cell in another folder. Thus it has to create the word file before it can be linked?
<o> </o>
I have a button that will put the names in alpha order.
<o> </o>
Cheers
Marty