Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlinks imported into Excel
I have a CRM system that allows me to export information into excel. As a
part of the export process I'm having the program generate what I hoped was a active hyperlink back to the specif record in the host application. I'm using the "HYPERLINK" function but it doesn't result in displaying the active hyperlink in the target cells. After export in excel I need to format the cells to general and then to select each cell and hit enter in the formula bar to convert it to a hyperlink. Way too tedeous! Is there a short cut or macro that could do this conversion for me? Or is there a way that I could set up the export routine logic differently? Below is an example of what is exported in excel... =HYPERLINK("https://na2.salesforce.com/0064000000907ry", "WRS - SOSCOE Studio - Eng Serv for LOCI 2.1 / LOS-SE 5.0 (March)") Thanks for your help! MarkB |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert imported Access Hyperlinks to Excel and KEEP the li | Excel Worksheet Functions | |||
Activate email hyperlinks in imported data | Excel Discussion (Misc queries) | |||
autocreating hyperlinks in excel? ie 500 cells to 500 hyperlinks? | Excel Programming | |||
Update 2000 Excel hyperlinks to 2003 hyperlinks | Excel Worksheet Functions | |||
How toi turn-off hyperlinks [excel]? Email hyperlinks pop up ! | Excel Discussion (Misc queries) |