Internet Fixes Weekly Microsoft Office 2000 News Letter

Oct 08, 2004http://internetfixes1.brinkster.net/chat!/chat.asp
 
Make WordPerfect documents coexist peacefully in a Microsoft Office!
Make WordPerfect documents coexist peacefully in a Microsoft Office world by saving them with the filename extension .doc. This lets Word open them automatically and display them in its File | Open dialog box. When you save a file, simply add .doc at the end of the filename. When your coworkers double-click on the file, Word will open it and transparently convert it into Word format.

If you don't have Word on your system, you can assign the .doc extension to WordPerfect so that all the files you create on your system will have that extension and will open automatically in WordPerfect. Use Tools | Settings, go to the Files tab, make sure that Use default extension on open and save is checked, and replace .wpd with .doc as the extension to use.
Data Entry Solutions with the Excel 2000 Template Wizard!
One of the hardest parts of gathering data from users is creating the right collection application. The data collection front end is often a series of forms in Access or ASP pages. However, the setup and security issues associated with these methods are sometimes too much to deal with for smaller data collection needs.

Excel 2000 ships with an add-in that can help this situation. The Template Wizard with the Data Tracking add-in will help you create an Excel template that will accept data from users in a familiar environment and then transfer the data to an Access database after it's saved. The wizard will walk you through the steps of defining the tables where the data should be inserted.
This is a great solution for such things as purchase order requests, invoices, or expense forms. Your users would enter their data in Excel, and the data structures set up by the Wizard would place that data into the Access database. The data would be collected into one repository for easy reporting and analysis.

The Wizard is easy to follow, but Microsoft Knowledge Base article Q214246 explains the process in detail. http://support.microsoft.com/support/kb/articles/Q214/2/46.ASP
Animating Powerpoint ClipArt in PowerPoint 2000!
How would you like to have a ClipArt picture put itself together right before the audience's eyes? To see how to create this kind of animation, run PowerPoint and choose Insert/Picture/ClipArt. Right-click the picture you want to use and choose Insert to place it on your slide. We suggest you use the knife, fork, and spoon set found under Signs.

Now select the picture, then choose Draw/Ungroup. Next, choose Slide Show, Custom Animation. When the dialog box opens, click the Effects tab. In the "Check to animate slide objects" list, click the first object. Then hold down the Shift key and scroll down to select the last object. With all objects selected, click the arrow at the right side of the "Entry animation and sound" list box and select an effect.

Now click the Order & Timing tab and then select the radio button labeled Automatically. Click OK to close the dialog box and then press F5 to run the slide show. Each part of the ClipArt picture will appear as you instructed when you chose an effect
Things to Note
Many Folks ask us how we cover so many topics. Most of our answers come from a Database with 42 Topics and over 8000 entries. This came from over 8 years of online help. Couple that with over 5000 documents on various subjects we have the ability to answer most of your questions.