| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Copy Hyperlink to another file as a HYPERLINK, not text...
XL2000= I have a form where I often insert a Hyperlink in Cell D19. Then a
macro pastes all 20 form entries (D1:D20) to a DBase. Problem is that D19 pastes as text, not as a link. Any macro that will recognize if D19 contains a HLink & then copy it to DBase as HL? thanx tom dollardoc |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to Copy Hyperlink to another file as a HYPERLINK, not text...
How exactly are you pasting to your DBase, and what form does the dbase
take? If I copy a range in Excel from one sheet to another the hyperlinks are preserved in Excel XP. Robin Hammond www.enhanceddatasystems.com "dollardoc" wrote in message ... XL2000= I have a form where I often insert a Hyperlink in Cell D19. Then a macro pastes all 20 form entries (D1:D20) to a DBase. Problem is that D19 pastes as text, not as a link. Any macro that will recognize if D19 contains a HLink & then copy it to DBase as HL? thanx tom dollardoc |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlink to a text file | Links and Linking in Excel | |||
| Turning a text file name into a search and linking the file as a hyperlink | Excel Discussion (Misc queries) | |||
| Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
| hyperlink file via macro? | Excel Programming | |||
| reading html when hyperlink address not hyperlink text diplayed | Excel Programming | |||
Linear Mode
