Hyperlinks

Static Hyperlinks

SpeedGen preserves all the Hyperlinks you've added in the Source Workbook. So something like your company URL would be preserved.

Dynamic Hyperlinks

But sometimes you need to construct Hyperlinks dynamically. A common example is grabbing URLs from a database and then hyperlinking them.

Dynamic Hyperlinks are actually quite simple. The secret is to use the Excel HYPERLINK() function.

The HYPERLINK() functions takes 1 or 2 parameters.

The first parameter is link_location. This is usually the URL although it could be other things.

The second parameter is the name to display for the link. This parameter is optional.

So if you want to use Field Markers to supply the data for the Hyperlink it is simple. If you have a Field Marker for the URL in Cell A2 and a Field Marker for the Display Name in Cell B2 then you could put =HYPERLINK(A2, B2) in Cell C2 and hide columns A and B so the user doesn't see the raw data. An alternative is to use columns near the far right of the worksheet to supply the raw data (like Columns IU and IV) and you could also hide those.

Finally, remember that Excel requires the "http://" or "ftp://" or other prefix in the link. You cannot simply put "www.test.com" . It should be "http://www.test.com". If your Field Marker only contains www.test.com then you could use the CONCATENATE() function to prefix the prefix to the data in cell A2. (The & Operator is a shorter alternative to CONCATENATE() - e.g. =A1 & B1 )