Book

Suggestions


Enter your email address:

Delivered by FeedBurner


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


  Sunday, June 21, 2009 – Permalink –

Clip Art at Home

Install more


Do you remember all of the clip art that was available locally with Office XP?

When you have an Internet connection, you have access to the Office Online collection, but if you would like more clip art installed on your machine:


A small amount of sample clip art images was included The 2007 Office systems and Office 2003 and is part of the "local collection" that is searched when you do not have Internet access to the Microsoft Office Online Clip Art and Media Web site. Office 2003 no longer included a media content CD with additional clip art. However, the Microsoft Office XP Media Content CD can still be installed locally or on a network share.

The Office XP Media Content CD contains approximately 35,000 clips that are a subset of the clips that are available on the Microsoft Office Online Clip Art and Media Web site. The Office XP Media Content CD was included with Microsoft Office XP Professional, Microsoft Office XP Standard, and Microsoft Publisher 2002 Deluxe Edition.

To install the contents of the Office XP Media Content CD on a computer, follow these steps:
  1. Exit all programs that are running

  2. Insert the Office XP Media Content CD into the CD drive or into the DVD drive
    (Hold down the SHIFT key to prevent the program from automatically starting. If Microsoft Windows Installer automatically starts, click Cancel)

  3. Click Start, click Run, type the following command, and then click OK: 
    msiexec.exe /i CD_drive:\CAG.MSI ADDLOCAL=ALL /qb
(CD_drive is the letter of the drive that contains the Office XP Media Content CD)
Support.Microsoft.com
How to add clip art to Clip Organizer in a 2007 Office system and in Office 2003




See all Topics

Labels:


<Doug Klippert@ 3:04 AM

Comments: Post a Comment

  Wednesday, June 17, 2009 – Permalink –

VBA Variable Problems

Explicit protection


It's good practice to always use the Option Explicit statement in the beginning of your code modules to ensure that all variables are unambiguously declared in your procedures.

With this process in place, you'll receive a "Variable not defined" error if you try to execute code containing undeclared variables. Without this statement, it's possible to mistype variable names, which would be interpreted as new Variant type variables.

This could severely impact the results of your code, and you might not ever know it. If you do find a problem, tracking down where the error is can be a chore.

Although you can manually type the statement into your modules, changing a setting in Access can ensure that the statement is always added to new modules.

  1. Open a module (start the VBA Editor)

  2. Choose Tools>Options from the menu bar

  3. On the Editor tab of the Options dialog box, select the Require Variable Declaration check box in the Code Settings panel

  4. Finally, click OK





See all Topics

Labels:


<Doug Klippert@ 3:36 AM

Comments: Post a Comment

  Monday, June 15, 2009 – Permalink –

SQL Warning in Word

Merge Ahead!


When you open a Word  mail merge main document that is linked to a data source, you may receive the following message:

Opening this will run the following SQL command:

SELECT * FROM C:\file_name.log

Data from your database will be placed in the document. Do you want to continue?


SQL Warning

This message helps protect you from unintentionally sending data to a malicious user.
To suppress this message, you must first create the following registry key:


  1. Open Registry Editor.
  2. Locate, and then click the following registry key:

    HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Word\Options

    (Use 12.0 for Word 2007)

  3. Click Edit, point to New, and then click DWORD Value.

  4. Under Name, type:

    SQLSecurityCheck

  5. Double-click SQLSecurityCheck.

  6. In the Value data box, type:

    00000000
See
Microsoft KB 825765

Installing Office XP SP3 appears to cause the same problem. For Word 2002 (XP also known as 10.0) you need to place the registry key in: HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Word\Options

(Thanks to Brian Livingston at WindowsSecrets.com for pointing the way to a solution)




See all Topics

Labels:


<Doug Klippert@ 3:15 AM

Comments: Post a Comment

  Monday, June 08, 2009 – Permalink –

Art and Words

One picture can mess up a thousand words


Linda Johnson has put together a well laid out basic tutorial about combining text and graphics on a page.

Aligning Text and Graphics in Word

I might have added "Edit Wrap Points"; a feature that allows more control over how text wraps around a picture. Also the use of Format>Picture from the menu. The Layout tab on the dialog box has an Advanced button. The Advanced Layout section presents more precise layout choices if needed.

Linda dismisses the Drawing Canvas that pops up in Word 2002+. I think she is correct, in most situations.

For more information on the "DC" see:
Drawing Canvas - More than I want



See all Topics

Labels: , ,


<Doug Klippert@ 3:34 AM

Comments: Post a Comment

  Tuesday, June 02, 2009 – Permalink –

PowerPoint Bloats Word

Diet tips


For various reasons, it can be helpful to send a PowerPoint show to Word. You can have great looking handouts and be able to format the document in ways that are not possible in PowerPoint.

The problem can be the size of the resultant file.

One of the easier, more practical ways to slim the doc down is to break the OLE links.
The size of a Word document may be 20 to 50 times larger than a PowerPoint presentation when you send the presentation to Word.
  1. Start PowerPoint.

  2. On the File menu, point to Send To, and then click Microsoft Office Word.

  3. Click Paste link, and then click OK.

  4. In the resulting Word document, click Links on the Edit menu.

  5. Select all the links that are listed, and then click Break Link.

  6. Click Yes when you are prompted.

  7. Save the Word document.
When you eliminate the OLE overhead, you can reduce the size of the Word document by 90 percent
Support.microsoft.com
 Size of Word Document




See all Topics

Labels:


<Doug Klippert@ 3:13 AM

Comments: Post a Comment