Tuesday, January 23, 2018

Office VBA Tricks

Video + Free code


"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

VBA Tips & Tricks

Getting Started with VBA in Office 2010

Download Office 2013 VBA Documentation


(VBA is VBA and is, in most cases, usable in all versions of Office)



See all Topics

Monday, January 22, 2018

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



See all Topics

Sunday, January 21, 2018

Onscreen Keyboard

Tap or Click?


If you would like to have a keyboard on your screen that can be activated with your mouse you're in luck

Type osk in Start Run






See all Topics

Saturday, January 20, 2018

Add Objects to Query Grid

Easy additions


If you need to add a table or query to a query you're building in Design view, you most likely click the Show Table button, drag the appropriate objects from the resulting dialog box, and then close the dialog box.

However, there's a much easier way to do this.

Simply drag the table or query object's icon directly to the gray background of the query design grid. This same technique also works with the Access Relationships window.



See all Topics

Friday, January 19, 2018

Chiropractics for Excel

Knead and pound numbers

Chad Rothschiller, a program manager on the Excel team, discusses using formulas to 'clean up' data in Excel.
Excel is a great tool to use when you need to take data in one format, manipulate it into another format, and push the results along to another process, e.g. a database. In this context, Excel is a great landing pad or middle man, serving as a data transformation tool to move data from one system to another.

This example considers a sample data set and walks through the steps to clean up the data and perform various transformations on the data set to massage it into a more desirable format.

I'm sure you've been faced with at least one of theses problems:

  • Import the data and don't accidentally drop the leading zeros!

  • Formatting SSN

  • Inserting hyphens

  • Fixing up names

  • Lower case E-Mail Address

  • Format Home Phone

  • Inserting parenthesis & hyphens

  • Trim extra spaces from Address

  • Add City values to the new table

  • Make all State value upper case

  • Fill in Postal Code

  • Finalize the values
Manipulate and massage  



See all Topics

Thursday, January 18, 2018

Image 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

Wednesday, January 17, 2018

Resetting the body clock

So very SAD


SAD

A wistful feeling comes over us in late autumn, as the last remaining leaves drop, morning frosts cover the ground, and the sun sets earlier each day. Hot cider and the warmth of a favorite old coat may be all you need to face the coming winter with good cheer, but for many people, fall melancholy deepens to winter depression.


Winter depression is still a mystery to scientists who study it. Many things, including brain chemicals, ions in the air, and genetics seem to be involved. But researchers agree that people who suffer from winter depression -- also known as "seasonal affective disorder," a term that produces the cute acronym SAD -- have one thing in common. They're particularly sensitive to light, or the lack of it.

"Research shows that bright light visual stimulation (light which enters the eyes), can change the timing of the body clock and its timing of sleep or awakening signals to the body. Thus, bright light therapy has been used to treat the range of disorders caused by a mis-timed body clock including shift work, jet lag, sleep onset and early morning insomnia mentioned above as well as winter depression (Seasonal Affective Disorder, SAD)."

"Probably the greatest use of bright light therapy is for the treatment of winter depression, especially in very northern countries which have little sunlight in the winter months. These sufferers appear to have delayed body clocks and benefit most from morning light therapy.

At present, the blue LED glasses are still experimental devices. They are not yet commercially available. The Flinders University owns the intellectual property rights and a provisional patent. A commercial partner to manufacture and market the devices under license is still being sought."

Seasonal Affective Disorder



See all Topics

Tuesday, January 16, 2018

Drawing Canvas

More than I want


The Draw layer has been around since about Word 97, but it has not been as intrusive as it is in Word 2002+.

Try to place an AutoShape on a page and the Drawing Canvas pops up by default.

To turn off this feature, go to:
Tools>Options.
On the General tab, remove the check mark from
"Automatically create drawing canvas when inserting AutoShapes"

To just dismiss it each time, choose your AutoShape and then touch the Delete or Esc key before drawing the object.

Here's some more information.


Knowledge Base
General Information About Floating Objects
(a discussion of Word's floating objects and layers)

As I understand it, the Drawing canvas is not really a new layer. The following illustration shows the classic layers. It is from the Knowledge base article:
How to Place Text over a Graphic


___________________
/                   /
/   <SURFACE OF     /
/       PAPER>      /
/                   /  /
Front drawing layer  -------------------  /
MAIN TEXT LAYER  =================== / /
Back drawing layer  -------------------/ / /
/ /
Front drawing layer  -------------------/ /
(Header/footer) BOTTOM TEXT LAYER  =================== /
Back drawing layer  -------------------/



You can dump the layer in 2007 in the Office button Word Option equivalent of Tools>Options:



Smart Art 2013



See all Topics

Monday, January 15, 2018

Free Contact Templates

Free electronic business cards


Microsoft has business card templates that can be used in Outlook.

Just download the file and edit the information.



Contact Cards



See all Topics

Sunday, January 14, 2018

Keyboard ALT Codes

Quick inserts


Here is a collection of Alt codes. There is also a free download that you can post near your computer.

  • Alt Codes for Letters with Accents for Languages
  • Alt Codes for Bullets, Symbols and Other Special Characters
  • Alt Codes for Mathematical Symbols - Symbols used in Mathematics
  • Alt Codes for Currency Symbols
  • Alt Codes for Drawing
  • Alt Codes for Characters from the Greek Alphabet
  • Alt Codes for "Additional" Letters particularly for Nordic / Scandanavian Languages
  • Alt Codes for Spanish
  • Intellectual Property Right symbols.
  • Alt Codes for Arrows
  • Alt Codes for Punctuation and Editing
  • Alt Codes in Computer Programming
Alt Codes



See all Topics

Saturday, January 13, 2018

Shuffle Music

Like those fruity machines


Microsoft Media player can do more things than just play the odd sound file. You can set it up to go through a play list is random order; playing music all day long.



Shuffle Sort



See all Topics

Friday, January 12, 2018

IE Temp Files

Storage area


Every once in awhile when the Berners-Lee pipeline clogs up, you are instructed to delete the temporary files that IE saves.

You can do it with the Click of an IE Options button.

Here's where those files are stored:




As you see, you could move that location if you wanted to.

Finding the Temporary Internet Files folder



See all Topics

Thursday, January 11, 2018

Spreadsheet Boo-Boos

Design suggestions


A few links to sites with advice on spreadsheet design and error detection.

European Spreadsheet Risks Interest Group:
Spreadsheet mistakes - news stories

Raymond R. Panko, PhD University of Hawaii

What We Know About Spreadsheet Errors



See all Topics

Wednesday, January 10, 2018

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

Tuesday, January 09, 2018

Gmail Features

The top 10


Bill Kee, Associate Product Marketing Manager for Gmail, has a blog and has listed 10 major features of the free web based email system.
Including:

"When you get an email that references an address, look to the right and you'll probably see a link from Gmail pointing you to a map of the address on Google Maps.

Gmail also recognizes email text that refers to an event (e.g., 'dinner tomorrow at 8pm'), and will give you a link to add it to your calendar.

It'll even pick up on package tracking numbers from UPS and link you directly to the tracking page, so you don't have to copy and paste the number. I really like this last one when I order stuff online and want the instant gratification of knowing a package is on its way.


Gmail features Part 1

Gmail features Part 2



See all Topics

Monday, January 08, 2018

Web Data

Numbers from the ether


Excel has had a feature called web query. Here's an add-in that makes it a little easier.

"The Excel 2007 Web Data Add-In makes it easy to use a Web page as a data source in Excel.

The add-in plugs into Excel 2007 seamlessly, its entry point located on the Data Tab under the From Web option. The system extracts data by learning from a user’s selection of data they wish to capture into Excel. The more selections, the more the system is trained."



Web Data

Getting data from the Web in Excel

2013 Web Data YouTube



See all Topics

Sunday, January 07, 2018

Charity or Scam

IRS worthy or not


Did someone call asking for money for the Global Relief Foundation, Inc. or some other charitable organization?

You can look them up with the IRS.

BTW, you might think again about these groups:
  • Benevolence International Foundation, Inc.
    Palos Hills, Illinois

  • Global Relief Foundation, Inc.
    Bridgeview, Illinois

  • Holy Land Foundation for Relief and Development
    Richardson, Texas

  • Rabbi Meir Kahana Memorial Fund
    Cedarhurst, New York
Search for Charities  

Revoked by IRS 


Here's the site for Washington state:
Secretary of State



See all Topics

Saturday, January 06, 2018

Outlook Shortcuts

Good Strokes


Check names--------------------------------------Ctrl + K or Alt + K
Check spelling-----------------------------------F7
Choose the account from which to send
a message(with focus on the To line)
and then TAB to the Accounts button------------Ctrl + TAB
Convert an HTML or RTF message to plain text-----Ctrl + Shift +O
Delete a mail message----------------------------Delete or Ctrl + D
Display the Address Book-------------------------Ctrl + Shift + B
Find a message ----------------------------------Ctrl + Shift + F
Find text----------------------------------------F3
Forward a message--------------------------------Ctrl + F
Go to folder-------------------------------------Ctrl + Y
Go to next mail message--------------------------Down or Up arrow
Insert signature---------------------------------Ctrl + Shift + S
Mark a message as read---------------------------Ctrl + Enter or Ctrl + Q
Move between the Folders list and message list---Tab
Open or post a new message-----------------------Ctrl + N
Open the Address Book----------------------------Ctrl + Shift + B
Open the Inbox-----------------------------------Ctrl + I
Open the Outbox----------------------------------Ctrl + O
Open the selected message------------------------Ctrl + O or Enter
Post to a folder---------------------------------Ctrl + Shift + S
Print the selected message-----------------------Ctrl + P
Reply to a message-------------------------------Ctrl + R
Reply to all-------------------------------------Ctrl + Shift + R
Send (post) a message----------------------------Ctrl + Enter or Alt + S
Send and receive mail----------------------------Ctrl + M or F5
Switch among Edit, Source, and Preview tabs------Ctrl + Tab
Switch to Inbox----------------------------------Ctrl + Shift + I
Switch to Outbox---------------------------------Ctrl + Shift + O 


Royal National Institute of the Blind:
Outlook Keyboard Shortcuts

Outlook 2013 shortcuts



See all Topics

Friday, January 05, 2018

MHTML

One file web pages



When a web page is created using HTML, the coding is normally contained in one file and the graphics in separate folders.

The Mime HTML or MHT/MHTML format changed that.

Starting with Office 2000 as an add-in and carried through XP as a "Web Archive" option, the format emerged in Office 2003 as a "Single file web page" selection in the File Save As dialog box.

Here are the Save As choices available in an application such as Word:
  • Web Page, Complete means that the contents of the page (including any pictures) will be saved into a folder as separate files, similar to those on the server hosting the site.

  • Web Page, HTML only means that only the HTML information will be saved. This option and Web Page, Complete will enable you to open the file for viewing in Internet Explorer (or any other browser) at a later time, even when you are offline.

  • Web Archive means that the page will be saved, along with any images it contains, as a single file. You can view a Web Archive later without being connected to the Internet.

  • Text File means that only the text on the page will be saved, not the HTML (or any other) formatting, including graphics.
MIME Encapsulation of Aggregate HTML Documents (MHTML)  

Short Summary of the MHTML Standard



See all Topics

Thursday, January 04, 2018

Product Key Finder

Search machine


You have a legal copy. You installed it and activated the application.

Now your machine blew up and you have to install it again. Where's the Product key? Probably gone sometime in the past 10 years.

"The Magical Jelly Bean Keyfinder is a freeware utility that retrieves your Product Key (cd key) used to install windows from your registry.

It has the options to copy the key to clipboard, save it to a text file, or print it for safekeeping.

It works on Windows 95, 98, ME, 2000, XP, Server 2003, Windows 7, Office XP, Office 2003, and Office 2007-10.


Keyfinder



See all Topics

Wednesday, January 03, 2018

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

Tuesday, January 02, 2018

Mailbox Diet

Prune the fat


Microsoft provides a tutorial on the mechanics of Outlook 2007 mailboxes.
Learning how to manage your Microsoft Outlook 2007 Mailbox and keep it within a specific size limitation.

After completing this course you will be able to:
  • View the size of your mailbox and its folders.

  • Understand what makes an e-mail message big and find the size of any message.

  • Set up some simple processes and use tools built into Outlook to prevent e-mail pileup from happening in the first place.
Battle mailbox size  

Performance problems with a large .pst file  

Manage with Mailbox Cleanup



See all Topics

Monday, January 01, 2018

DOS Were the Days

Take CMD


Here's an introduction to the Command Prompt:
Command Line


Microsoft has provided product documentation on the use of the Command line in Windows.

Hopefully this won't be something you need in an emergency.
Use it in good health.

Details for Command line

  • Cmd
  • Command-line reference A-Z
  • Command shell overview
  • Change the command history settings
  • Change the size of the command prompt cursor
  • Change command prompt display option settings
  • Change the command prompt screen layout
  • Change command prompt window Edit Options settings
  • Copy and paste MS-DOS text using the mouse
  • Change MS-DOS command prompt window fonts
  • Change colors of command prompt elements




See all Topics

Sunday, December 31, 2017

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




See all Topics

Saturday, December 30, 2017

High Res Wallpaper

Details apparent


Choose from a broad selection of free pictures to use for wallpaper.

Download sizes from 1920x1200 to 320x240.



Free High-Resolution Widescreen Wallpaper



See all Topics

Friday, December 29, 2017

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

Word 2010 to PP 2010



See all Topics

Thursday, December 28, 2017

Last Name First

Phonebook style


Sort the Contacts list by the File as field.

To do this, use one of the following methods depending on the version of Outlook that you are using.

In Outlook 2007+, follow these steps:

1. Start Outlook 2007+.

a. On the Tools menu, click Account Settings.

b. Click the Address Books tab, and click Change.

c. Under Microsoft Office Outlook Address Books, click the address book that you want to change the contact display format for.



For example, Contacts: Mailbox - Personal Folders, and then click File As (Smith, John).

In Outlook 2003, follow these steps:

1 Start Outlook 2003.

a. On the Tools menu, click E-mail accounts.

b. Click View or change directories or address books, and then click Next.

c. Click Outlook Address Book, and then click Change.

d. Under Outlook Address Books, click the address book that you want to change the contact display format for. For example, Contacts: Personal Folders, and then click File As (Smith, John).

e Click Close, and then click Finish.

2. Quit and restart Outlook.

3. Verify that the newly created contacts are sorted in the LastName, FirstName format. To do this:

a. On the Tools menu, click Options.

b. Click the Preferences tab, and then click Contact Options.

c. In the Contacts Options box, click Last, First in the Default File As order list.

d. Click OK two times.

4. Edit the properties of any contacts that have the File as option configured individually. This setting overrides the setting that you made in step 1.

a. Double-click any contact that does not appear in the LastName, FirstName format in your Contacts list.

b. Click the General tab, click the down arrow next to File as, and then click Lastname, Firstname, where Lastname, Firstname is the name of the contact.

Lastname first

Outlook 2010



See all Topics

Wednesday, December 27, 2017

All the Basics

All(most) all you need to know


Office.Microsoft.com has a short demo that shows you the main things anyone needs to know about Excel.

There are many thousands of users who find that this is all they ever need.
  • Add numbers
  • Subtract numbers
  • Multiply numbers
  • Divide numbers
Use simple formulas to do the math



See all Topics

Tuesday, December 26, 2017

New Window

Pick your target



Expression Web/FrontPage/HTML provides the opportunity to choose how a page opens when you click on a hyperlink.

Create a hyperlink as you usually would by selecting the text (or graphic) you want to use for the link.

Choose Insert > Hyperlink...
(or use Ctrl-K or the toolbar icon Link icon as a shortcut),
and locate the page in the current web or enter an address in the URL field.

On the right side of the Create Hyperlink window you'll see a button named "Target frame"; click the button.

You'll get the Target Frame dialog box.

In the "Common targets" field, select New Window.

Click OK, then click OK to close the Create Hyperlink dialog box.

Your hyperlink will now open a new browser window when clicked.

Target page

The code would appear like this:
<a target="_blank" href="TCC/Blog/blogger.html">Blog</a>

To make it the page default, place the following code in the "head" section:
<base target="_blank">




See all Topics

Monday, December 25, 2017

Night Skies

The real stars




JPL NASA

Also:
Arachnoid.com
In 1826, the astronomer Heinrich Olbers asked, "Why is the sky dark at night?" By his time, physicists had learned enough to realize that, in a stable, infinite universe with an even distribution of stars, the entire universe should gradually heat up.

You will also discover the connection between a rubber band, your refrigerator, and the universe.

Photographs:
Events in the night sky

StarDate Online
StarDate is the public education and outreach arm of the University of Texas McDonald Observatory.

English and Spanish radio programs air daily on more than 500 stations.

Fourmilab Switzerland
To make a sky map, enter the latitude and longitude of your observing site and press the "Make Sky Map" button

This site is developed and maintained by John Walker, founder of Autodesk, Inc. and co-author of AutoCAD:

Space Watch
by Imaginova Spaceware



See all Topics

Sunday, December 24, 2017

Null Parameter

Show something


If a user doesn't specify a parameter value, you can use a wildcard with the parameter in the format
Like [Enter Name] & "*"

The problem with this is that the query will return records that partially match the criteria.

For instance, if users searching for records based on last name enter a parameter value of "Smith" they'll also get the records for Smithers, Smithfield and Smithson.

Another problem is that the parameter query will ignore any records where the field being searched contains a Null value when you try to return the entire recordset with a blank parameter.

To fix this, set up a query to limit responses to explicit parameter entries, but still allow users to return all records by leaving the parameter blank.

If you're searching for LastName, open the query design grid and add LastName to it.

In the Criteria row for the field, enter the parameter prompt
[Enter Name]

Then, in the next blank column of the design grid, enter the same parameter (everything between and including the square brackets) in the Field text box.

Finally, in the Or row, enter the criteria Is Null .

If you're using any additional criteria for other fields, make sure to copy that criteria to the Or line as well.



See all Topics