Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding hyperlink after the existing data in the cell
Hi all,
Is it possible to create and add the hyperlink after the existing data in the cell(that is, in the next line after the existing data in the same cell). So what i'm trying to do is, to get an outlook email, store email as .msg file in my folder and then add hyperlink to the just stored file in a particular cell in my worksheet. I can do all the things except for appending the hyperlink. As i create the hyperlink and add it in the cell selected by user, all the data in that cell is just overwritten by the hyperlink. So after this i only have the hyperlink in the cell and all the data that was there in the cell is lost. so is it possible to keep both , the existing data and hyperlink added in the cell. i tried reading the data of the cell into a variable before creating and adding hyperling. then i added the hyperlink in the cell. then i concatenated the data and hyperlink and then i made this concatination as the value of cell. but with this process, all the data is converted into the hyperlink, that is data that was there before the hyperlink is also a part of hyperlink text now. so is it possible to have normal text and hyperlink together in 1 cell. my code is.... existingData = SelCells(j).Value ActiveSheet.Hyperlinks.Add Anchor:=SelCells(j), _ Address:=FullPath, TextToDisplay:=Filename hyperlinkString = SelCells(j).Value SelCells(j).Value = existingData & vbCrLf & hyperlinkString thanx for any help amit |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I hyperlink to a cell in existing workbook? | Excel Discussion (Misc queries) | |||
adding data to an existing column with content | Excel Discussion (Misc queries) | |||
Adding % to existing cell values | Excel Discussion (Misc queries) | |||
Adding data to existing data that has a unique number in column | Excel Discussion (Misc queries) | |||
adding data to existing data cell | Excel Worksheet Functions |