Right off the bat I can't imagine what you're doing wrong. But I'm not
familiar with 'sf.com' Have you tried formatting the cells in Excel as
General first, or do you have that opportunity (if sf.com is creating the
workbook, I guess you don't).

If you're creating new workbooks with this all the time, you could put the
code I wrote into your Personal.xls workbook, or into any workbook at all and
just open that workbook along with one of the created workbooks. You'd need
to change
Worksheets(linkSheetName).
to
ActiveSheet.
in the code and make sure the sheet with the =HYPERLINK( formulas in it is
active in the workbook when you run the macro. At least you'd only have to
put the code into one workbook that way rather than continually be adding it
to a number of workbooks.

"MarkB" wrote:

JLatham,

Is there something that I'm doing wrong with the export routine that I'm
using in sf.com to create the logic of this formula such that when imported
into excel it doesn't create the hyperlink automatically? It may be more
beneficial to fix that than to install a macro to do the conversion after the
spreadsheet is created.

Let me know you thoughts

Mark

"JLatham" wrote:

Are you sure things aren't working right? The formula looks good and should
work. Could it be that the cells simply aren't displaying as a hyperlink
(blue underlined text)? If you click the cell initially, does the link work
or not? Should even if not displayed as blue underlined text. If it's just
an appearance thing, you can select them all and set to blue and underlined.



"MarkB" wrote:

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