Office 97 - Lan / Internet Tips

Access
the
Net With Office 97, the world is your hard drive. In addition to local and network drives, you can now open and save documents in FTP sites on the Internet. In any Office app except Outlook, select File/Open from the menu bar, click the down arrow next to the Look In box, and scroll to the bottom. There you'll find Internet Locations (FTP). Click it to search available FTP sites for your file. If this is the first time you're accessing files from a particular FTP site, select Add/Modify FTP Locations to add the new location.
You can also save files to an FTP site by clicking File/Save As, clicking the Look In box's down arrow, and scrolling down to Internet Locations (FTP).

Managing
Hyperlinks Word 97 automatically turns URLs into hyperlinks. As soon as you put the space after .com, .org, or whatever, the address turns blue, gets underlined, and launches a Web browser when you click it.
But that's not the whole story. Right-click your new link, and select the Hyperlink option. From the options there, you can add the link to your Favorites folder, correct a broken link, or copy the link to the Clipboard.

Hyperlink
to Other
Office
Documents
and the
Web In Word and PowerPoint documents and Outlook email messages, you can use hyperlinks to jump to other Office documents on your hard disk or network--or out to Web pages:

Highlight the word(s) you want to use as a link, and press Ctrl-K.

In the Insert Hyperlink dialog box that appears, enter the URL or path and filename you want to link to, or click Browse to track it down. If your browser is running and has the relevant page loaded, switch to the browser. This automatically puts the URL in the Link To box.

Optionally, add a name reference to a place within the document that you're pointing to. Click OK, and the selected word(s) will appear as an blue underlined hyperlink.

Make
Hyperlinks
Graphical In addition to blue underlined text hyperlinks, you can create navigational graphics (but not image maps) in Word, Excel, and PowerPoint documents:

Insert a graphic or piece of WordArt.

Select it, and press Ctrl-K.

In the Insert Hyperlink dialog box that appears, enter the URL or path and filename you want to link to, or click Browse to track down the address. (If your browser is running and has the relevant page loaded, switch to the browser. This automatically puts the URL in the Link To box.)

Optionally, add a name reference to a place that you're pointing to within the document.

Stay
Up to Date
on the Net Clear the Microsoft download pages from your Web browser's Bookmarks or Favorites list--you don't need them anymore. Now you can zoom to download pages, FAQs, Web tutorials, online help, and the latest info on Office 97 tools.
Just select "Microsoft on the Web" from any Help menu, and click any item that has the Web icon next to it to start the process. Office fires up your browser and points it to the right page. In no time at all, you have the very latest scoop on Office 97, direct from Microsoft.

Get
the Latest
Stock
Quotes Use Web Queries to pull information from the Web directly into Excel 97:

Select Data/Get External Data from the menu bar, and click Run Web Query.

You'll see a dialog box with available query files. Double-click "Detailed stock quote by PC Quote, Inc."

Designate where you want to put the quote, and enter the symbol for the stock you're interested in.

Use Data
from
Live
Web Sites Excel 97 lets you get live data from a Web-based spreadsheet and then manipulate it in your own Excel spreadsheet:

Open the spreadsheet to the page to which you want to link (type or paste its URL into the File Open dialog box).

Select and copy the cells you want in your Excel spreadsheet.

Switch to your worksheet, select Edit/Paste Special from the menu bar, and click the Paste Link button.

Setup
Web
and
FTP
Sites
on Your
Computer Microsoft's free Web/FTP server, the Microsoft Personal Web Server, is great for testing and proofing your Web content:

Download Personal Web Server from the Server Software section of Microsoft's download page.

Save the file to a temporary directory, then use Windows Explorer to run it.

The file will install itself automatically. When it's installed, place your HTML files into the \webshare\wwwroot directory, and put the files you want to share over the Internet in the \webshare\ftproot directory.

Other people can now access these files over the Internet via your IP address. (If you're behind a firewall, only people on your local network will be able to access your site.) To find out your IP address, click the Start button, select Run, type winipcfg, and hit Enter. (Note that your IP address may not be a permanent one; it may change each time you log on to the Internet or to your local area network. Ask your Internet service provider or network manager for more details about your IP address.)

Ask
Microsoft
for
Help Microsoft's Office 97 Resource Kit is a work-in-progress technical reference for installing, configuring, and supporting Office 97 in workgroups. If you can't find answers to your questions through the Office Assistant or via Help/Microsoft On The Web, try the Resource Kit.

Web
Publishing
Wizardry If you've built your own Web page using Office 97's Web editing capabilities, you'll want to publish your page for the world to see. The Web Publishing Wizard, available for download from Microsoft's site, walks you through the process of posting your files to your ISP or to your organization's intranet or LAN.

Hosted by www.Geocities.ws

Access the Net	With Office 97, the world is your hard drive. In addition to local and network drives, you can now open and save documents in FTP sites on the Internet. In any Office app except Outlook, select File/Open from the menu bar, click the down arrow next to the Look In box, and scroll to the bottom. There you'll find Internet Locations (FTP). Click it to search available FTP sites for your file. If this is the first time you're accessing files from a particular FTP site, select Add/Modify FTP Locations to add the new location. You can also save files to an FTP site by clicking File/Save As, clicking the Look In box's down arrow, and scrolling down to Internet Locations (FTP).
Managing Hyperlinks	Word 97 automatically turns URLs into hyperlinks. As soon as you put the space after .com, .org, or whatever, the address turns blue, gets underlined, and launches a Web browser when you click it. But that's not the whole story. Right-click your new link, and select the Hyperlink option. From the options there, you can add the link to your Favorites folder, correct a broken link, or copy the link to the Clipboard.
Hyperlink to Other Office Documents and the Web	In Word and PowerPoint documents and Outlook email messages, you can use hyperlinks to jump to other Office documents on your hard disk or network--or out to Web pages: Highlight the word(s) you want to use as a link, and press Ctrl-K. In the Insert Hyperlink dialog box that appears, enter the URL or path and filename you want to link to, or click Browse to track it down. If your browser is running and has the relevant page loaded, switch to the browser. This automatically puts the URL in the Link To box. Optionally, add a name reference to a place within the document that you're pointing to. Click OK, and the selected word(s) will appear as an blue underlined hyperlink.
Make Hyperlinks Graphical	In addition to blue underlined text hyperlinks, you can create navigational graphics (but not image maps) in Word, Excel, and PowerPoint documents: Insert a graphic or piece of WordArt. Select it, and press Ctrl-K. In the Insert Hyperlink dialog box that appears, enter the URL or path and filename you want to link to, or click Browse to track down the address. (If your browser is running and has the relevant page loaded, switch to the browser. This automatically puts the URL in the Link To box.) Optionally, add a name reference to a place that you're pointing to within the document.
Stay Up to Date on the Net	Clear the Microsoft download pages from your Web browser's Bookmarks or Favorites list--you don't need them anymore. Now you can zoom to download pages, FAQs, Web tutorials, online help, and the latest info on Office 97 tools. Just select "Microsoft on the Web" from any Help menu, and click any item that has the Web icon next to it to start the process. Office fires up your browser and points it to the right page. In no time at all, you have the very latest scoop on Office 97, direct from Microsoft.
Get the Latest Stock Quotes	Use Web Queries to pull information from the Web directly into Excel 97: Select Data/Get External Data from the menu bar, and click Run Web Query. You'll see a dialog box with available query files. Double-click "Detailed stock quote by PC Quote, Inc." Designate where you want to put the quote, and enter the symbol for the stock you're interested in.
Use Data from Live Web Sites	Excel 97 lets you get live data from a Web-based spreadsheet and then manipulate it in your own Excel spreadsheet: Open the spreadsheet to the page to which you want to link (type or paste its URL into the File Open dialog box). Select and copy the cells you want in your Excel spreadsheet. Switch to your worksheet, select Edit/Paste Special from the menu bar, and click the Paste Link button.
Setup Web and FTP Sites on Your Computer	Microsoft's free Web/FTP server, the Microsoft Personal Web Server, is great for testing and proofing your Web content: Download Personal Web Server from the Server Software section of Microsoft's download page. Save the file to a temporary directory, then use Windows Explorer to run it. The file will install itself automatically. When it's installed, place your HTML files into the \webshare\wwwroot directory, and put the files you want to share over the Internet in the \webshare\ftproot directory. Other people can now access these files over the Internet via your IP address. (If you're behind a firewall, only people on your local network will be able to access your site.) To find out your IP address, click the Start button, select Run, type winipcfg, and hit Enter. (Note that your IP address may not be a permanent one; it may change each time you log on to the Internet or to your local area network. Ask your Internet service provider or network manager for more details about your IP address.)
Ask Microsoft for Help	Microsoft's Office 97 Resource Kit is a work-in-progress technical reference for installing, configuring, and supporting Office 97 in workgroups. If you can't find answers to your questions through the Office Assistant or via Help/Microsoft On The Web, try the Resource Kit.
Web Publishing Wizardry	If you've built your own Web page using Office 97's Web editing capabilities, you'll want to publish your page for the world to see. The Web Publishing Wizard, available for download from Microsoft's site, walks you through the process of posting your files to your ISP or to your organization's intranet or LAN.