Enter your email address:

Delivered by FeedBurner



Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?
Home Page

Bloglines

1906
CelebrateStadium
2006


OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal












Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!

 


eXTReMe Tracker
  Web http://www.klippert.com



  Tuesday, May 13, 2008 – Permalink –

Embed a Show

Stick it in Word



You might like to distribute a short PowerPoint slide show, and include some extra material.

Open Word and PowerPoint.

Arrange the windows so that both applications can be seen.
(Right-click an empty area of the Task bar and choose "Tile Windows Vertically."

Type your introductory text in the Word document.

Switch to PowerPoint and open the PowerPoint file.

In Slide Sorter View, hold down the Ctrl key and select the slides you want to include.

Drag the selected group of slides onto the Word document.

You will only see the first slide in the document, but if you double-click on the image, the PowerPoint show will run.

It will also work in Excel.

(This, of course assumes that the target machine has PowerPoint or PowerPoint Viewer installed)

[Edited entry from 1/8/2005]




See all Topics

Labels: , ,


<Doug Klippert@ 6:16 AM

Comments: Post a Comment


  Sunday, May 11, 2008 – Permalink –

Forms and Slides

PowerPoint in Access


This download provides an Access database and a PowerPoint slide show.

"Create a PowerPoint slide presentation from scratch using Access data. In addition, display and control a slide show from within an Access form. Walk through the solution and explore ways to extend the sample for your own applications.

This article looks at two ways of interaction between Access and PowerPoint.

The first sample illustrates how to create a PowerPoint presentation from the data in an Access table using Automation.

The second sample shows how to display and manipulate an existing PowerPoint presentation inside of an Access form, also using Automation."

Here is an MSDN article:
Working with PowerPoint Presentations from Access Using Automation

If you have some knowledge of VBA, you can probably figure it out from the code on the Access Form.



Office 2003 Sample:
Working with PowerPoint 2003 Presentations from Access 2003 Using Automation


[Edited entry from 1/13/2005]




See all Topics

Labels: ,


<Doug Klippert@ 6:20 AM

Comments:
Powerpoints presentation is really very good for presentation and how to display and manipulate an existing powerpoint slides presentation inside of an Access form, also using Automation
 
Post a Comment


  Monday, April 14, 2008 – Permalink –

Click to Trigger

Make it so



A trigger is an object on your PowerPoint slide - a picture, a shape, a button, or even a paragraph or text box. When you click on it an action is initiated. The action might be a sound, a movie, an animation, or text becoming visible on the slide.

Microsoft Office Online has a tutorial:
Use triggers to create an interactive slide show in PowerPoint

"Here's a Power User column for teachers. Want to involve your students more in a presentation? Set up "triggers" for them to click as they go through the show. Triggers (related to animations) let you add surprise to your slides while inviting your viewer to take part and have fun."


Indezine.com:
Trigger Animations


All 'Bout Computers:
Trigger Happy Animations in PowerPoint

[Edited entry from 12/24/2004]




See all Topics

Labels:


<Doug Klippert@ 6:21 AM

Comments: Post a Comment


  Saturday, April 05, 2008 – Permalink –

'Tis the Template

Free Holiday templates


This can be considered a jumping off point for many holiday themed templates.
Here are some sources for holiday backgrounds and clipart for PowerPoint. These sites also have material for the rest of the year.

All 'Bout Computers:
Holiday AutoShapes in PowerPoint
by Kathy Jacobs

Template Ready:
Christmas FREE PowerPoint Template

Microsoft office:
Holiday templates

Presenters University:
(Free login)
Holiday templates

Brainy Betty:
Christmas and Holiday Themed Templates

Sonia Coleman:
Free PowerPoint Templates


[Edited entry from 12/15/2004]




See all Topics

Labels:


<Doug Klippert@ 6:09 AM

Comments:
Find some more free templates at this site.
 
Post a Comment


  Thursday, April 03, 2008 – Permalink –

PP News Groups

We're all in this together



PowerPoint Newsgroup:
Discussions in PowerPoint General Questions


WOPR.com:
Lounge - PowerPoint board


TechRepublic.com
Office Questions


TheOfficeExperts.com:
Office Experts - PowerPoint


RDPSlides.com:
How do I join the PowerPoint newsgroup?

Presentation Helper

[Edited entry from 11/5/2004]




See all Topics

Labels:


<Doug Klippert@ 6:55 AM

Comments: Post a Comment


  Monday, March 24, 2008 – Permalink –

Educational Slide Shows

Suggestions


Purdue University has a collection of PowerPoint shows on a number of topics.

  • Writing Skills
  • Research and Documentation St yles
  • Grammar and Mechanics
  • Business/ Professional Writing
  • Agricultural Economics/Cooperative Extension


If you have eve had to prepare a paper with MLA/APA standards these shows may come in handy:

Cross-referencing: Using MLA Format
This presentation teaches your students the purposes of MLA documentation, as well as methods for using parenthetical citations and a Works Cited page. This presentation is an important addition for the beginning of a research unit in a humanities course or any assignment that requires MLA documentation. (Writer and Designer: Jennifer Liethen Kunka)

Documenting Sources: Using APA Format
This presentation reviews the purposes of APA documentation, as well as methods for effectively using parenthetical citations and a reference page. This presentation is ideal for the begin ning of a research unit in a science course or any assignment that requires APA documentation. (Writer and Designer: Jennifer Liethen Kunka).


Purdue University



See all Topics

Labels:


<Doug Klippert@ 5:34 AM

Comments: Post a Comment


  Saturday, March 22, 2008 – Permalink –

Default Save

Choose your own location



When you choose to save most Office files, the Save dialog box defaults to the Documents or My Documents folder.

(The following directions work in 2007, but you need to click on the Office button in the upper left corner of the Window)

Word
you can change the default location by going to Tools>Options. On the "File Locations" tab you can modify the storage location.

Excel
Tools>Options. On the "General" tab change the default location.

PowerPoint
uses Tools>Options and the "Save" tab.

Access
Tools>Options and the "General" tab for Databases and Projects

Publisher
Tools>Options "General".

Outlook
will make you take an underground tour into the Registry to change the location to save e-mail attachments.

FrontPage/Expression Web
appears to require the same sort of spelunking.


Change the folder where e-mail messages and attachments are saved

Also:
D.C. Everest school district Weston, WI:
Office Default Paths

If you don't want to change the default, but would like to be able to quickly go to an alternate site, open the Save or Save Attachment dialog box. On the left side of the box is the Places Navigation bar. If you click the Desktop icon, that location will be used to save the file.

You can add spots to the bar. Browse to the specific folder. Highlight the folder and click the down arrow beside the Tools option. Select "Add to My Places."

The file or e-mail attachment can then be saved where you want.

[Edited entry from 11/05/2004]




See all Topics

Labels: , , , ,


<Doug Klippert@ 7:42 AM

Comments: Post a Comment


  Wednesday, March 19, 2008 – Permalink –

Beyond Bullet Points

By Cliff Atkinson


ISBN 0-7356-2052-0
Microsoft Press 2005

About the Author
Cliff Atkinson is a leading authority on how to improve communications across organizations using Microsoft PowerPoint. He is a popular keynote speaker, a writer, and an independent management consultant whose clients include companies ranking in the top five of the Fortune 500. He is president of Sociable Media in Los Angeles.

Cliff teaches at UCLA Extension, is a senior contributor for the MarketingProfs newsletter, and writes the Beyond Bullets weblog, at BeyondBullets.com.
Also see SociableMedia.com


Book Description
PowerPoint owns the presentation world. We've been cocooned by a blue gradient screen with six or more bullet points feeding information.
Or so we've been lulled to believe.
(see Edward Tufte's dissection of the Columbia PowerPoint disaster)

Cliff Atkinson takes a well researched, but almost heretical stand that a presentation is a story and that too much data plastered on the screen, dulls the audience's soul and actually reduces comprehension and retention.

Beyond Bullets walks the reader through the story process and provides tools to structure presentations to have the maximum impact.

The "PowerPoint" part of the process is easy to follow, even for a novice. The story telling sections will help improve the most experienced speaker's show.


Quote

"But what might not be evident in the simplicity of this slide is what happens when the audience experiences it along with your verbal explanation. Because the slide design is simple, the audience can quickly scan the headline and visual and understand the idea. Then their attention turns to the place you want it. — to you, the words you're saying, and the way the information relates to them. Instead of making everything explicit and obvious on the slides, you can leave the slides open to interpretation so the audience is dependent on you, and you on them.

What (the experts are) saying, basically, is that slides filled with bullet points create obstacles between presenters and audiences. You might want to be natural and relaxed when you present, but people say that bullet points make the atmosphere formal and stiff. You might aim to be clear and concise, but people often walk away from these presentations feeling confused and unclear. And you might intend to display the best of your critical thinking on a screen, but people say that bullet points "dumb down" the important discourse that needs to happen for our society to function well.

Somewhere in our collective presentation experience, we're not connecting the dots between presenters and audiences by using the conventional bullet points approach. This issue is of rising concern not only to individuals and audiences - even the major players of large organizations are taking notice of the problem. It seems that in every location where people meet, from small meeting rooms to board rooms to conference halls, people want a change."

Here's the latest edition:



[Edited entry from 3/1/2005]



See all Topics

Labels: , ,


<Doug Klippert@ 5:32 AM

Comments: Post a Comment


  Friday, March 14, 2008 – Permalink –

No Bullets?

Heresy!


Cliff Atkinson's book, "Beyond Bullets", came out in 2005. A new version has just been released updating it to 2007.

Shellie Tucker, of Office.Microsoft.com, tried out the suggestions in a real world situation:

"It was a gamble. And it gave us pause. Could we give a PowerPoint presentation and use NO BULLET POINTS? Could we divorce ourselves from the tried and true - and deadly boring? We decided to try."

No bullets



See all Topics

Labels:


<Doug Klippert@ 7:45 AM

Comments: Post a Comment


  Tuesday, March 04, 2008 – Permalink –

Move that Thing

Noise and motion


Microsoft has another of its easy to understand tutorials that deals with making objects move on the screen and also make sounds.


  • Animate text or objects

  • Add sound effects to an animation or hyperlink

  • Use sample animations in your presentation

There is also a link to a tutorial about adding sound effects to a presentation.

Animation



See all Topics

Labels:


<Doug Klippert@ 7:28 AM

Comments: Post a Comment


  Thursday, February 28, 2008 – Permalink –

PP7 Fixes PP3

Repair PowerPoint 2003 charts


"Consider the following scenario:
  • You apply a design theme to a presentation in Microsoft Office PowerPoint 2007.
  • You insert an embedded Microsoft Office Excel chart object into a slide in the presentation.
  • You save the presentation in the PowerPoint 97-2003 Presentation (*.ppt) format.

In this scenario, when you open the presentation in Microsoft Office PowerPoint 2003 and then edit the chart, the theme information that is applied to the chart is lost. Instead, the default Microsoft Office color theme is applied to the embedded Excel chart object. Additionally, the text in the chart changes, and the chart shrinks.

Note This problem also occurs if you create a .doc file by using Microsoft Office Word 2007. Then, when you edit the chart object in Microsoft Office Word 2003, you experience these symptoms."

PowerPoint 2007 and Word 2007 use Excel to insert charts.

When the file is saved in 97-2003 format, you lose that feature.

According to MS,
"To work around this problem, use one of the following methods:
  • Do not edit the chart in PowerPoint 2003.
  • If you edit the chart in PowerPoint 2003, remove the chart. Then, use PowerPoint 2007 to reinsert the chart."


Knowledgebase 945002



See all Topics

Labels:


<Doug Klippert@ 7:00 AM

Comments:
A couple alternatives to Microsoft's workarounds:

1. Don't edit the presentation in 2007.
2. Use MS Graph to insert the chart (Insert tab > Object).

 
Excellent observation!
Just because you have Excel available to do charting, you don't have to use it.
Go to Object on the Insert tab and choose MS Graph.

Thanks

 
Post a Comment


  Monday, February 25, 2008 – Permalink –

Legacy files from 2007

Go back


Read this article closely. If you work in a situation where you need to work with legacy (pre-2007) files, it may be handy.

If you do most of your work in 2007, I wouldn't bother.


"When you use Windows Explorer or the desktop to create a new 2007 Microsoft Office file, a new Office file is created in an XML file format (.dox or .xlsx). For example, this behavior occurs when you right-click the desktop, you point to New, and then you click Microsoft Office Word Document. By default, files that you create in the 2007 Office system are in XML file formats.

This article is about how to create legacy Office files, such as .doc files, .xls files, .ppt files, or .mdb files in the 2007 Office system. You can create legacy Office files without opening any Office applications. To do this, you must modify some settings. The modified settings will apply to all the users who log on to the computer."

Knowledgebase 935787



See all Topics

Labels: , , ,


<Doug Klippert@ 7:46 AM

Comments: Post a Comment


  Thursday, February 21, 2008 – Permalink –

VBA, Named Arguments

An easier read


Use named arguments for cleaner VBA code.


Most likely, you use positional arguments when working with VBA functions. For instance, to create a message box, you probably use a statement that adheres to the following syntax:

 MsgBox(prompt[, buttons] [, title] [, helpfile, context])


When you work the MsgBox function this way, the order of the arguments can't be changed.

Therefore, if you want to skip an optional argument that's between two arguments you're defining, you need to include a blank argument, such as:
MsgBox "Hello World!", , "My Message Box"


Named arguments allow you to create more descriptive code and define arguments in any order you wish. To use named arguments, simply type the argument name, followed by :=, and then the argument value.

For instance, the previous statement can be rewritten as:

MsgBox Title:="My Message Box", _
Prompt:="Hello World!"


(To find out a function's named arguments, select the function in your code and press [F1].)



See all Topics

Labels: , , ,


<Doug Klippert@ 7:53 AM

Comments: Post a Comment


  Sunday, February 17, 2008 – Permalink –

15 Minutes to Presentation

Show suggestions


Here are a few links that may stir up your presentation skills. You don't have to follow all of them, but there may be one or two that will help.

Having to present a report to a group is not something that most people do every day. There are sources that will help you develop an interesting, successful "show"


One spot that has a lot of information and free downloads is
Presenters University

Here's a collection of tips that may help:
15 Minute Guide to Winning Presentations


Microsoft Small Business:
Presenting with PowerPoint: 10 do's and don'ts
By Cherie Kerr


PresentationPointers.com
Summary of Article Sections


Communicating Effectively
Articles and tips - on all aspects of public speaking, formal, informal presentations and meetings; overcoming fear, fielding questions, hostile audiences, effective techniques, using anecdotes, spellbinding speeches, using multimedia for impact.

Building A Presentation
Tips and articles on using powerpoint and other presentation and related programs includes a data base of tips and tech notes from Microsofts Powerpoint related sites. Effective handouts, planning and using projectors.

Planning A Presentation
Articles to assist in the formative stages of creating a great impression. Hiring a speaker, what to include in your presentation, making a presentation memorable.

Beyond Bullets:
Board Fires CEO Over PowerPoint
By Cliff Atkinson

[Edited entry from 11/19/2004]



See all Topics

Labels:


<Doug Klippert@ 7:27 AM

Comments: Post a Comment


  Monday, February 11, 2008 – Permalink –

PPT Font Size

How big should you go?


In the old days of slide shows, presenters would hold their slides out at arm's length. If they could still see the text, then it would be OK when projected.

Dave Paradi has researched the question and offers a PDF document that compares screen size, fonts, and seating distance.

For instance:


"For example, if you're using a 60 inch screen and have 32 point text on your slides, the furthest someone should be is 57 feet from the screen."


Font Size

Dave Paradi's PowerPoint Tip



See all Topics

Labels:


<Doug Klippert@ 7:55 AM

Comments: Post a Comment


  Thursday, January 24, 2008 – Permalink –

Slideshow Accessibility

Hearing and vision enhanced


Dave Paradi has an article about how to design PowerPoint shows for those with limited hearing or vision.

With PowerPoint presentations becoming more of a standard way to communicate information of all types, we need to keep in mind that our first responsibility is to our audience. We need to use the ideas above to make sure that we make our presentation accessible for everyone.

Making Accessible Slides



See all Topics

Labels:


<Doug Klippert@ 6:51 AM

Comments: Post a Comment


  Sunday, January 20, 2008 – Permalink –

Replace Fonts

A type change



PowerPoint has a feature that allows you to replace any of the fonts being used in a presentation
You may want to do this to change the look of a show, or because the type face is not available on another machine and not embeddable.
Go to Format>Replace Fonts.

Choose one of the fonts you are currently using and its replacement.

Look over your presentation before saving it. Sometimes a different font will change the spacing on a slide. You may have to reformat a few slides

RDP Slides.com:
Troubleshoot font problems

Informit.com:
Working with Text in PowerPoint

MS Office Assistance:
Why won't Replace Fonts work?
Understanding Unicode fonts

[Edited entry from 12/5/2004]




See all Topics

Labels:


<Doug Klippert@ 6:42 AM

Comments: Post a Comment


  Friday, January 04, 2008 – Permalink –

PowerPoint Pundits

Connect with other PowerPoint users


Microsoft has put together a list of locations, forums, blogs, etc. that cover PowerPoint.

You'll probably find that your question has been answered at one of these spots.

Office.Microsoft.com



See all Topics

Labels:


<Doug Klippert@ 7:35 AM

Comments: Post a Comment


  Saturday, December 29, 2007 – Permalink –

Viewer

Portable PowerPoint



If you have to show your presentation on a machine that does not have PowerPoint installed, you can use " Package for CD. "

Before 2003 it was named "Pack and Go."

Go to File> Package for CD ...
The Dialog box will walk you through the process and offer to include the PowerPoint Viewer.

PowerPoint Viewer

The problem with the earlier versions of PowerPoint, through 2002, was that the viewer only handled the features available in PowerPoint 97.


The PowerPoint 2003 Viewer lets you view full-featured presentations created in PowerPoint 97 and later versions.

Here is the download location for the PowerPoint 2003 Viewer:

Microsoft 2003 PowerPoint Viewer



Here's the PowerPoint 2007 viewer:
PP 2007 Viewer

Microsoft:
What happened to Pack and Go?

How to package and copy a presentation to a CD in PowerPoint 2003

Leave a good impression; distribute a business presentation on CD

"Want to truly impress your customers with a multimedia presentation about your business? You can easily make your Microsoft Office PowerPoint 2003 presentations more portable by burning them onto a CD. By including the new free PowerPoint 2003 presentation viewer on the CD, presentations can be distributed to and viewed by audiences who do not use Microsoft Office."

PP Tools:
Downloads and descriptions for other versions

[Edited entry from 11/3/2004]



See all Topics

Labels:


<Doug Klippert@ 8:38 AM

Comments: Post a Comment


  Sunday, December 16, 2007 – Permalink –

Office VBA tricks

Video + Free code



Quick tips VBA Video


"Learn tips and use sample code for several Office applications. These tips can help you to be more productive and can also be a starting point for developing your own tools, utilities and techniques."


  • Update Word Document Statistics in the Title Bar
  • Create Outlook Rules Programmatically
  • Delete Repeated Text Throughout a Word Document
  • Run Macros Based on the Value of One or More Excel Spreadsheet Cells
  • Disable Related Controls on a PowerPoint Slide After a User Clicks an Input Control
  • Display Reminder Information When a User Opens an Office Document
  • Synchronize an Access Main Form to a Subform and Vice Versa
  • Log Worksheet Changes to an XML File
  • Merge Body Text from Multiple Outlook E-mail Messages to a Word Document
  • Use the Office Assistant as an Alternative to Displaying and Retrieving User Input


Ten Tips for Office VBA Developers


[Edited entry from 10/22/2004]




See all Topics

Labels: , , , ,


<Doug Klippert@ 5:00 AM

Comments: Post a Comment


  Saturday, December 15, 2007 – Permalink –

Background Templates

Fresh material



After seeing a few PowerPoint presentations, all of the backgrounds and graphics included with Office, start to look alike.


Luckily, there are generous folk who supply fresh material.


Sonia Coleman is one of the best.


She presents over 200 templates for download.

Free PowerPoint Templates


Explore the rest of her site including the Gallery section

Also see:

PoweredTemplates.com

[Edited entry from 10/21/2004]


See all Topics

Labels:


<Doug Klippert@ 6:56 AM

Comments: Post a Comment


  Wednesday, December 12, 2007 – Permalink –

Images Sources

No cost


After awhile the graphics in Office Clipart or even the ones found on Microsoft's Office online appear the same.

Here is a list of 100 locations for royalty free stock images.




Free stock images



See all Topics

Labels: , , ,


<Doug Klippert@ 5:50 AM

Comments: Post a Comment


  Friday, November 30, 2007 – Permalink –

YouTube in PowerPoint

Imbedded videos


Shyam Pillai has provided a free wizard to imbed YouTube clips into a PowerPoint Presentation

"Use this to insert YouTube videos into a PowerPoint slide. All you need to do is to provide the YouTube video URL that appears in the browser address bar, the rest is taken care of by the YTV Wizard.

Note: YouTube videos are streamed so a live internet connection is required to playback the video during the slideshow. Use the free FlashBack add-in to play/rewind the YouTube video automatically."

YouTube Video Wizard



See all Topics

Labels:


<Doug Klippert@ 7:03 AM

Comments: Post a Comment


  Thursday, November 22, 2007 – Permalink –

New Tables in Town

Bigger and better (?)


Pre '07 versions of PowerPoint limited tables to a maximum of 25 rows and columns. You were able to ungroup the table cells before, but that has been taken away.


"In this release, we have increased that maximum to 75x75 within the UI.

We were able to do this because we made the decision to move away from the metaphor of a table simply being a group of shapes, as it was in previous versions.
This has been one of the largest enabling factors in our performance gains, and as a result, tables are workable at sizes much greater than that of 25x25.

A tradeoff made in order to obtain these gains in performance was the ability to "ungroup" a table.

While this tradeoff means that there are a set of scenarios no longer present, specifically the ability to ungroup a table to animate individual pieces, we feel that the performance gains (not to mention all the other aspects talked about in this section of the blog) along with the ability to use multiple tables and/or shapes in these scenarios will benefit users in a much greater way."


PowerPoint Tables


It can still be done:


Workaround for animating a table:

  1. Right-click the table, choose Save as Picture

  2. Save as EMF (choose EMF from the "save as type dropdown list)

  3. InsertPicture, insert the EMF

  4. Ungroup the EMF twice

  5. Now regroup the parts you need to animate -- rows, columns, or whatever


microsoft.public.powerpoint



See all Topics

Labels:


<Doug Klippert@ 6:50 AM

Comments: Post a Comment


  Saturday, November 17, 2007 – Permalink –

Move the Show

Portable hints


A speaker can be called upon to present programs almost anywhere. Every site is unique and has its own problems. Your show may, also, have to be sent out on its own.

Here are some suggestions that may help on the road:

Distributing PPTs - Pitfalls, Panics & Pleasures
By Steve Rindsberg


There are several potential problem areas:


  • Recipients who don't have PowerPoint
  • PowerPoint version compatibility
  • Links - to images, sounds, movies and OLE content (graphs, charts, spreadsheets, Word pages etc.)
  • Sound and movie compatibility
  • Fonts
  • Timing/Synchronization
  • VBA code and Controls
  • Recipients using assistive technology

[Edited entry from 10/13/2004]



See all Topics

Labels:


<Doug Klippert@ 6:02 AM

Comments: Post a Comment


  Wednesday, November 14, 2007 – Permalink –

Word to PP

Send outline to PowerPoint


That old 2003 version allowed you to send a Word file to PowerPoint and have it create a slide show.

After styling with Heading 1, 2, etc, go toFile > Send To > Microsoft Office PowerPoint.

2007 is a little different (duh!)


For Microsoft Office 2007

Word 2007 doesn't allow you to publish to PowerPoint 2007 by default.
Here's the solution:

After you are done in Word 2007, save it as a Word document.

Now open PowerPoint 2007.

Click on the Office Button at the top left hand corner.

Click Open.

Under Files of type, select All Outlines.

Now select the Word document and click Open.

Alternately,

In Word 2007, right click on the ribbon.

Select Customize Quick Access Toolbar.

Under "Choose commands from:", select Commands not in the ribbon.

Look for "Send to Microsoft Office PowerPoint".

Click OK.

The command will then be added onto the Quick Access Toolbar (QAT).




Word to PowerPoint


See all Topics

Labels: ,


<Doug Klippert@ 5:18 AM

Comments: Post a Comment


  Tuesday, November 06, 2007 – Permalink –

Google Shows

Presentation alternative


Google Docs now has a presentation element.

You can create documents, spreadsheets and presentations online.

They're a bit restricted and simplexat this point, but you can also import files and convert them for sharing or publication.

Google Docs

Review of Google presentation


See all Topics

Labels:


<Doug Klippert@ 5:06 AM

Comments: Post a Comment


  Saturday, November 03, 2007 – Permalink –

Automation - VBA - Help File

Office Wide


"Automation (formerly known as OLE Automation) is a feature of the Component Object Model (COM), an industry-standard technology that applications use to expose their objects, methods, and properties to development tools, macro languages, and other applications.

For example, a spreadsheet application might expose a worksheet, chart, cell, or range of cells--each as a different type of object. A word processor might expose objects such as an application, document, paragraph, bookmark, or sentence.


When an application supports Automation, the objects that the application exposes can be accessed through Visual Basic. You can use Visual Basic to manipulate the objects by invoking methods or by getting and setting properties of the objects."


Here's an example:


Inserting Data into a Microsoft Word Document

With Automation code, you can open a Microsoft Word document and move to a bookmark location in the document. The following example opens a Microsoft Word document and inserts text after a bookmark.

This example assumes that you have Microsoft Word on your computer, that you have an existing document called C:\My Documents\WordTest.doc, and that the document contains a pre-defined bookmark named City.


Sub FindBMark()

Dim wordApp As Word.Application
Dim wordDoc As Word.Document
Dim wordRange As Word.Range

Set wordApp = CreateObject("Word.Application")
Set wordDoc = wordApp.Documents.Open("C:\My Documents\Wordtest.doc")

wordApp.Visible = True

' Go to the bookmark named "City".
Set wordRange = wordDoc.Goto(What:=wdGoToBookmark, Name:="City")
wordRange.InsertAfter "Los Angeles"

' Print the document.
wordDoc.PrintOut Background:=False

' Save the modified document.
wordDoc.Save

' Quit Word without saving changes to the document.
wordApp.Quit SaveChanges:=wdDoNotSaveChanges

Set wordApp = Nothing

End Sub



Microsoft Support provides an entire Help file to assist you. It includes theory and examples.

The file is called XPAutomation.chm.

Download it and then double click on the file to run it. You could also set up a shortcut on the desk top, if it will be used frequently.


Microsoft Knowledge Base Article: 302460


This was aimed at Office 2002 but it can be used with later versions:

  • Microsoft Access
  • Microsoft Excel
  • Microsoft Outlook
  • Microsoft PowerPoint
  • Microsoft Word





See all Topics

Labels: , , , ,


<Doug Klippert@ 6:45 AM

Comments: Post a Comment


  Monday, October 29, 2007 – Permalink –

Handy Master View

It's mouse and keyboard quick!


With PowerPoint 2007, View>Presentation Views>Slide Master will take you to the Slide Master View. The same location shows Handout and Notes Masters.

A shortcut involves using the Shift key.


"At the bottom left hand corner of PowerPoint (bottom right for PowerPoint 2007), you will see 3 mini buttons. They are: Normal View, Slide Sorter View, and Slide Show. Now here's a quick trick:

When you hover over these 3 mini buttons, hold down the Shift key. The mini buttons will now become Slide Master view, Handout Master view, and Set Up Show respectively."


The Setup Show is on the Slide Show tab in the Setup group. The Shift key is a cooler way to bring it up quickly.



The Art of PowerPoint-ing


Thanks to Lucy, an MOS Master Instructor from Australia; aneasiertomorrow.com.au.



See all Topics

Labels:


<Doug Klippert@ 6:53 AM

Comments: Post a Comment


  Thursday, October 25, 2007 – Permalink –

2003-2007 Compatibility

Exchange the future and the past


"Microsoft has added new file formats to Microsoft Office Word, Excel, and PowerPoint 2007. To help ensure that you can exchange documents between Microsoft Office releases, Microsoft has developed a Compatibility Pack for the Office Word, Office Excel, and Office PowerPoint 2007 File Formats"


Use earlier versions of Excel, PowerPoint, and Word to open and save files from 2007 Office programs


Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007



See all Topics

Labels: , ,


<Doug Klippert@ 6:40 AM

Comments: Post a Comment


  Saturday, October 20, 2007 – Permalink –

Acrobat PowerPoint

Convert PP to Acrobat


First, be aware that this is not for everyone. You may not have a need to do this, and/or may not want to shell out more software money.
This requires Adobe Acrobat Pro, which runs about $449 retail.
(See: PowerPoint Viewer)


How to Create Slide Shows and Self-running Kiosks in Acrobat

"First, make sure you're using the right Acrobat software. With Acrobat Standard, you can add sound to documents but you can't import video clips. To create documents containing both video and sound, you'll need to use Acrobat Professional, which contains all the tools necessary for integrating media in PDF documents.

Acrobat is not a presentation-authoring program, so you'll need to use an application like PowerPoint to create your presentation. Some people use page-layout software to create presentations, but for animated effects, PowerPoint is the easiest tool for adding motion to both text and objects.

Add your desired animation and motion effects in PowerPoint before exporting to PDF. The visuals you create in PowerPoint display in an Acrobat viewer after PDF creation as long as you follow a few rules."


PlanetPDF offers other Acrobat tricks.


There is also:
Acrobat Reader Slideshow.pdf

PDFzone.com

[Edited entry from 10/5/2004]



See all Topics

Labels:


<Doug Klippert@ 6:22 AM

Comments: Post a Comment


  Saturday, September 29, 2007 – Permalink –

Move the Line

Animate charts


PowerPoint has the ability to present elements of a graph one at a time for dramatic effect.


Here's one take from PPTWorkBench.com:
Complex Animations


This tutorial is an example of making PowerPoint do things that can't normally be done. In this case, we will tweak some chart animations that don't exist under normal circumstances.
  1. Create a chart with data,
  2. Ungroup the chart into individual pieces,
  3. Insert pictures that relate to the data,
  4. Do some grouping + animation.

Also:
Microsoft:
Animate Chart Elements in Microsoft PowerPoint

Internet4classrooms.com:
Animating a Chart - Using Ungrouping

Ungroup in 2007

[Edited entry from 9/14/2004]



See all Topics

Labels:


<Doug Klippert@ 7:52 AM

Comments: Post a Comment


  Wednesday, September 26, 2007 – Permalink –

Send Your Template to MS

Geek fame


According to the Inside Office Blog, over 1 million people have downloaded free templates from Microsoft.


"You probably have a document you use over and over again, something you created to solve a particular problem. You may even find yourself occasionally sending the document to others in e-mail because it's so useful. Now you can share your clever solution with everyone who uses the 2007 Microsoft Office system!

People like you all over the world are allowing others to download and use their document templates on Office Online. Some of these templates have tens of thousands of downloads. They were submitted by people who either wanted to help others or show their great solutions. You can, too.



Upload your template


See all Topics

Labels: , , , ,


<Doug Klippert@ 7:08 AM

Comments: Post a Comment


  Friday, September 14, 2007 – Permalink –

Annoying Hypertext Warning

How to disable hyperlink warning messages in 2007 Office programs


When you include links in PowerPoint, or other '07 applications, you may get this admonition:
Opening "path/filename".
Hyperlinks can be harmful to your computer and data. To protect your computer, click only those hyperlinks from trusted sources.
Do you want to continue?


To disable the hyperlink warnings in 2007 Office programs when an http:// address or an ftp:// address is used, you must create a new registry subkey.

To do this, follow these steps:

  1. Click Start, and then click Run.

  2. In the Open dialog box, type regedit, and then click OK.

  3. In Registry Editor, locate one of the following registry subkeys:
    HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Common 

    HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\12.0\Common

    Note You only have to modify one of these registry subkeys. You do not have to modify both of them.

  4. Click the registry subkey, point to New on the Edit menu, and then click Key.

  5. Type Security, and then press ENTER to name the key.

  6. On the Edit menu, point to New, and then click DWORD Value.

  7. Type DisableHyperlinkWarning, and then press ENTER to name the entry.

  8. In the right pane, right-click DisableHyperlinkWarning, and then click Modify.

  9. In the Edit DWORD Value dialog box, click Decimal, and then type 1 under Value data.

    Note A value of 0 enables the hyperlink warning message. A value of 1 disables the hyperlink warning message.

  10. Click OK.

  11. Exit Registry Editor.



How to disable hyperlink warning messages


Security warning message



See all Topics

Labels:


<Doug Klippert@ 6:08 AM

Comments: Post a Comment


  Monday, September 03, 2007 – Permalink –

Enlarge and Shrink Picture

Get a