Specifying Addresses for the Various Hyperlink Types

The details regarding how the various Hyperlink types are specified are provided below:

Web or local document: To insert a link to a URL which starts with www, you need only type in the address (e.g., www.goldsim.com). To insert a link to a URL which does not start with www, you must specify the transfer protocol (e.g., http://website.com).

To insert a link to some other document (e.g., a Word document or a PowerPoint presentation), you can provide the full path (e.g., C:\Docs\Projects\report.doc), or if the document is in the same directory as the model file, you can provide just the file name. That is, if you only provide a file name, GoldSim will look for the document in the active directory (the directory containing the current model file). You can also use the Browse… button to find a particular file to which you wish to create a hyperlink.

One common type of document that you may wish to open is a Microsoft Excel file (*.xls, *.xlsx or *.xlsm). When opening a spreadsheet file, in some cases you may want to immediately jump to a specified location (sheet and cell range) when opening the file.  GoldSim provides specialized syntax to support this. The syntax is as follows:

Filename#sheetname!cellrange (e.g., Book1.xlsx#Sheet1!a1:c3)

The following points should be noted:

o The entire text can be wrapped in quotes.  This should be done if the filename or sheet name contain any spaces.

o For an Excel file, GoldSim will recognize extension .xls, .xlsx, or .xlsm.

o The filename can be specified as a relative or absolute path. Absolute filenames must start with the drive letter or be a UNC path (starting with “\\”). Relative paths can contain “.” and “..” as well as folder names (e.g., “.\..\DataFolder\file.xlsx”). Relative filenames with no path are assumed to refer to the folder in which the model file is located.

o # is the delimiter between the filename and the sheet name.  It is optional (you do not need to provide a sheet name).The sheet name is not case-sensitive.

o ! is the delimiter between the sheet name and the cell range.  It is optional (you do not need to provide a cell range). The cell range can refer to a single cell (e.g., A2) or a range (e.g., A1:A3).

Email to…: When you click on an email link, it opens your default email program with the specified address in the “To” field.  You should enter an email address (e.g., support@goldsim.com).

FTP: To insert a link to an ftp site, simply type in the address (e.g., ftp.asite.com).

Execute Command: This allows you to run a specific application. This can be useful, for example, if you wish to open a document with an application which is not the default application with which the file extension is associated:

C:\graphics\paint.exe c:\images\bitmap.doc

Note that when using this type of Hyperlink, if the filename has spaces in it, it must be enclosed in quotation marks:

 C:\graphics\paint.exe "c:\images\my bitmap.doc"

Go to Element. This causes GoldSim to immediately jump to (but not open) the specified element. You can also specify a full path when using the element command. When you do so, the path name must start with a backslash:

\Container1\Container2\XYZ

Open Container. This causes GoldSim to immediately display the contents of the specified Container. GoldSim searches upward through the containment hierarchy from the current location and jumps to the first Container with the specified name. If you need to be more explicit (i.e., you have multiple Containers with the same name), you can also specify a full path when using the Container command. When you do so, the path name must start with a backslash:

\Container1\Container2\Container3

Open Dashboard. This causes GoldSim to immediately jump to the specified Dashboard. You can also specify a full path when using the Dashboard command. When you do so, the path name must start with a backslash:

\Container1\Container2\InputScreen

Related Topics…

Learn more about: