Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a hyperlink from data inserted into a feild
I'm trying to automate a process of automatically creating a hpyerlink so a
web document so that I don't have to manually type out the hyperlink stuff for every feild. Example: i want to view a user picture from http://example.com/pics/username.jpg where username would be replaced by the info put into the UserID feild. Be aware that I have no prior programming skills so treat me like a baby please :-D I have a feeling this will require some VB but I hope there is a simpler way. Thanks for the help! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a hyperlink from data inserted into a feild
Say we have in column A a list of names like:
mike bob joe tom In B1 enter: =HYPERLINK("http://www.example.com/pics/" & A1 & ".jpg") and copy down -- Gary''s Student - gsnu200775 "Noremac430" wrote: I'm trying to automate a process of automatically creating a hpyerlink so a web document so that I don't have to manually type out the hyperlink stuff for every feild. Example: i want to view a user picture from http://example.com/pics/username.jpg where username would be replaced by the info put into the UserID feild. Be aware that I have no prior programming skills so treat me like a baby please :-D I have a feeling this will require some VB but I hope there is a simpler way. Thanks for the help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Inserted HTML text as Hyperlink | Excel Worksheet Functions | |||
Create link with sheet which is not inserted into workbook | Excel Discussion (Misc queries) | |||
Create link with sheet which is not inserted into workbook | Excel Discussion (Misc queries) | |||
How can a hyperlink be inserted upon checking a checkbox? | Excel Programming | |||
hyperlink cell value inserted | Excel Worksheet Functions |