!! hyperlinks to listbox column - Possible?

A

ArmsteR

How can i extract the hyperlink path from an excel column and get it
pasted into a column in a listbox along with the link title ?


File Page Size

drawing1 A4
drawing2 A3
drawing3 A3
drawing4 A4


To display in the listbox like:

File Page Size link

drawing1 A4 \\server\drawings\drawing1.dwf
drawing2 A3 \\server\drawings\siteinvestigations\drawing2.pdf
drawing3 A3 \\server\drawings\old\drawing3.dwg
drawing4 A4 \\server\drawings\housetype\drawing4.pdf

I hope this makes sense!




I've got nearly every part working of my script to have an inbuilt
batch printing setup on my drawing register files which will be posted
on here when i finish but this is fairly cruicial.

Thanks
Dave
 
J

Joel

There are two seperate items. The address(Path) and the textotdisplay (what
appears on the worksheet).

MsgBox Range("D6").Hyperlinks(1).Address
MsgBox Range("D6").Hyperlinks(1).TextToDisplay
 

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


Top