Macro to Copy Hyperlink to another file as a HYPERLINK, not text...

D

dollardoc

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
 
R

Robin Hammond

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fire event code with Hyperlink and copy/paste RadioButtons 3
How to Open a Hyperlink 5
copy text from textbox to another application 3
Click on a hyperlink to hide or show a spreadsheet 4
Excel Worksheet_change with 2 functions to insert date and hyperlink window 0
Using a Macro to Hyperlink to another Excel Workbook. 1
how do I change a hyperlink to text 3
Create hyperlink via macro? Word 2007 2

Top