Pasting from the clipboard to the address box of inserthyperlink dialog window in vba
 

after

Application.Dialogs(xlDialogInsertHyperlink).Show

what would be the next line of code to paste the contents of the clip
board into the Address field?

Jay

Pasting from the clipboard to the address box of inserthyperlink dialog window in vba
 

Application.Dialogs(xlDialogInsertHyperlink).Show

is equivalent to doing it with the menu, so You would probably need to use
sendkeys before that command. Code wouldn't run while it is displayed.


--
Regards,
Tom Ogilvy


"Jay Fincannon" wrote in message
...
after

Application.Dialogs(xlDialogInsertHyperlink).Show

what would be the next line of code to paste the contents of the clip
board into the Address field?

Jay

Pasting from the clipboard to the address box of inserthyperlink dialog window in vba
 

My answer assumes you don't want to use the add method of the hyperlinks
object for some reason. (you have no access to what is in the clipboard
might be a reason and your unwilling to execute a paste to collect the
information).

--
Regards,
Tom Ogilvy

"Jay Fincannon" wrote in message
...
after

Application.Dialogs(xlDialogInsertHyperlink).Show

what would be the next line of code to paste the contents of the clip
board into the Address field?

Jay

Pasting from the clipboard to the address box of inserthyperlink dialog window in vba
 

thank you Tom, here's is what i'm up to.
i'm going thru route books and establishing links to google maps for
each street. is there a better way to do this.




On Mon, 4 Sep 2006 21:28:17 -0400, "Tom Ogilvy"
wrote:

My answer assumes you don't want to use the add method of the hyperlinks
object for some reason. (you have no access to what is in the clipboard
might be a reason and your unwilling to execute a paste to collect the
information).