E
Ellen G
I am building a macro that will automate the first few steps of building a
hyperlink. Because I don't know the location or name of the file to which the
hyperlink will point, I would like the user to complete the process past a
certain point.
So, I have the following items in the macro thus far (for 2007):
Application.SendKeys ("%NI")
Application.SendKeys ("%L")
This opens the Hyperlink dialog box and then activates the Look In block.
Now I would like to direct it to a certain directory in the Look In block
allowing the user to complete the hyperlink path.
How to I direct the Look In to something like: p:\Marketing\Clients
Thanks for your help.
Ellen
hyperlink. Because I don't know the location or name of the file to which the
hyperlink will point, I would like the user to complete the process past a
certain point.
So, I have the following items in the macro thus far (for 2007):
Application.SendKeys ("%NI")
Application.SendKeys ("%L")
This opens the Hyperlink dialog box and then activates the Look In block.
Now I would like to direct it to a certain directory in the Look In block
allowing the user to complete the hyperlink path.
How to I direct the Look In to something like: p:\Marketing\Clients
Thanks for your help.
Ellen