5.15.3 Creating a Hyperlink to a Word Document

Hyperlink is a mechanism by which you can jump to a location in the current document or Web page or to a different Microsoft Word document or a Web page or to a file that war created in a different program. You can even use hyperlinks to jump to multimedia files such as sounds and videos. In the exercise below you will create a hyperlink that jumps from a Microsoft Word file to a chart in Microsoft Excel that provides more details. A hyperlink is represented by a “hot” image or display text – which is often blue and underlined – that the reader clicks to jump to a different location.

1. In the new Microsoft Word document, type – Click Payroll worksheet to see the details of the payroll master.  

2. Select the text – Payroll Worksheet.

3. Save the Microsoft Word document by the name TRIAL.

4. Click on the Hyperlink button.
   Hyperlink dialog box becomes on screen.

5. Click on the Browse button.
   Link to File dialog box is now open.

6. Select Payroll and click on OK.
   You will be back onto the Link to File dialog box with the path and the filename of PAYROLL.xls.

7. Click on the OK button.
   You will be back to the document and you will see that the words Payroll Worksheet will be blue and underlined.
   As you move the pointer over the text, the pointer shape changes to that of hand and you can click over it. As you click, immediately you move onto the Payroll worksheet.

8. Click on the Back key button. It will take you back to the Microsoft Word document having the hyperlink. Observe that the link is now of a different colour.

9. Close the Microsoft Word document.

5.15.4  Using the Internet Assistant Wizard

For working in this section, you will require Internet Assistant. It is an add-in program and is not automatically installed in a typical Microsoft Excel installation. To test whether it is installed or not, simply click on the File menu. If the Save as HTML command option is available, it is installed and if it does not appear, you will have to install this add-in program. In case of any difficulty, refer to the Microsoft Excel online Help for more information about installing it.

Let us suppose you want to make the REPORT.xls worksheet available to other users of your organisation on the Internet or on the Internet. One way of doing it is to publish the worksheet data onto a Web page by converting the data to an HTML document.

Take up the steps listed below to covert worksheet data to an HTML document:

1. Open the REPORT.xls worksheet and select the range A1:F11

2. Click on the File menu and select Save as HTML…

The Internet Assistant Wizard – Step 1 of 4 dialog box opens as shown in .

In this wizard, you can add or remove data ranges and charts to or from the HTML document. Take a note that both the select range and the chart sheet is listed in the Ranges and chart to convert: list box.

3. In order to select both the data and the chart and to the next Wizard step, 

    click on the Next> button.

You can create a new HTML document i.e. the Web page or add the selected data and charts to an existing Web page in this dialog box. In order to create a new HTML document go the next step.

4. In Internet Assistant Wizard – Step 2 of 4 dialog box verify if the Create an independent, ready-to-view HTML document option button is selected. If it is not, select it.

5. Click the Next button.

The Internet Assistant Wizard – Step 3 of 4 dialog box appears.

The Data and the By name data will be a different one on your screen.
At this moment, you can edit the title or the header description and place horizontal lines before and after the data or chart in this dialog box. In its default settings, the title that will appear on a Web browser title bar is the workbook name. The header that will appear in the body of the HTML document is the sheet tab name. Take up the steps listed below to accept the default title and header and to add some descriptive text and horizontal lines:

6. In the Header: list box replace Sheet1 by typing Sales Data

7. Place the pointer onto the Description below Header: text box.

8. Type Congratulations to the entire Sales Team for the fantastic sales performance.

9. Click on the option-Insert a horizontal line before the converted data. check box to insert a check mark.

10. Click the Insert a horizontal line after the converted data. check box to insert a check mark.

11. Type your name in the By text box.

12. Click on the Next> button.

13. Verify that in the Code page selection list box. US/Western European is selected.

14. Verify that the Save the result as an HTML file. option is selected.

15. Type the path and the filename in the file path: 

      text box or Browse to select the path and type in the filename.

16. Click on the Finish button.

Viewing the Web Page

Your Web Page is now ready for viewing. You can connect to your ISP (Internet Service Provider), if desired, but is not necessary. This is so because you saved the HTML document as a local file i.e. on your hard disk drive. This permits to open the local file without connecting to an ISP. Take up the steps listed below to view the Web page:

1.Minimize the Microsoft Excel application.

2. Click on the Internet Explorer browser from the desktop.

There is a likelihood that if you do not connect to your ISP, an error message may indicate that browser cannot find the default Start page (Microsoft.com). In such case, simply click on OK to clear the error message and proceed.

3. Click on the File menu and open the Web Page just made. It opens on the Internet Explorer Browser.

Copyright © 2001 Selfonline-Education. All rights reserved.