madforgolf
Board Regular
- Joined
- Oct 20, 2006
- Messages
- 177
- Office Version
-
- 365
- 2016
Hi Folks,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><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-com
Is it possible to create a macro or code for the following issue?
<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
I have a button that will put the names in alpha order.
<o
Cheers
Marty