| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I turn off the clipboard icon when cut and pasting? | Setting up and Configuration of Excel | |||
| Pop-up clipboard window | Excel Discussion (Misc queries) | |||
| Pasting from Excel Clipboard with VBA Macro | Excel Programming | |||
| Disable Clipboard Dialog Box during Macro | Excel Programming | |||
| Macro - Pasting clipboard in a find box | Excel Programming | |||
Linear Mode
