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