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


  Thursday, July 23, 2009 – Permalink –

Excel VBA Help File

Download from Microsoft


Here is a downloadable compiled Help file covering the vagaries of Excel VBA.

You can use this file without having to, necessarily opening the application.

Excel 2003 VBA Language Reference




See all Topics

Labels:


<Doug Klippert@ 3:58 AM

Comments: Post a Comment

  Thursday, July 16, 2009 – Permalink –

65,539 Question

The eleventh place error


Sure, you got a recall notice on your new car because the drink holder was the wrong size.

Big deal, Excel 2007 also has/had a problem with some calculations.


The result of the calculation is a number from 65534.99999999995 to 65535. The calculation is performed correctly. However, the result is incorrectly shown as 100000.

The result of the calculation is a number from 65535.99999999995 to 65536. The calculation is performed correctly. However, the result is incorrectly shown as 100001.


Excel 2007 hotfix package

Calculation Issue Update




See all Topics

Labels:


<Doug Klippert@ 5:39 AM

Comments: Post a Comment

Access-Excel-XML-HTML

Transfer data


XML makes data transferable between applications.
Here is a tutorial with downloadable files.
Some simple guidance of how to transfer data from Excel or Access into HTML web pages using XML data files. VBA programs can be used to export data tables from Excel or Access into simple XML files. There are several examples of using different methods to display the XML and XSL files on web pages in order to quickly share your data with others.


An introduction to Excel and XML data files

 Also:
Some nice photos and calendar layout:
Monthly calendar with photos




See all Topics

Labels: ,


<Doug Klippert@ 3:56 AM

Comments: Post a Comment

  Wednesday, July 15, 2009 – Permalink –

Restore Defaults

Office 2003 redo


To reset the original settings in Office 2003, follow these steps.
Make sure that you back up your files before you follow these steps.
  1. 1. Start any Office 2003 program.
  2. On Help menu, click Detect and Repair.



  3. Click to select the Discard my customized settings and restore default settings check box, and then click Start.
  4. Quit the application, and then click Ignore.
  5. Click OK when you receive the following message:
    Reset of setting to default succeed.

Microsoft Office Diagnostics in 2007 replaces Diagnose and Repair:

Howtogeek.com




See all Topics

Labels: ,


<Doug Klippert@ 3:28 AM

Comments: Post a Comment

  Sunday, July 12, 2009 – Permalink –

Plain Numbers

I'd Like to Make It Clear


Plain Figures is a method of transforming statistical and financial data into figures, tables and graphs that people readily understand.

Have you ever:
  • squinted your eyes trying to see the numbers in a PowerPoint presentation?

  • scratched your head at a charity leaflet with an indecipherable pie chart titled 'Where your donation goes' ... and set it aside?

  • missed discussion at a meeting because you were busy trying to figure out the figures?

  • put aside a graph or table, thinking "I'm not good with numbers."?

Then you know how important the clear display of numerical information can be. Common problems People have trouble using numerical information for many reasons. Most commonly, authors don't know:
  • what to include: when unsure what numbers are important, people frequently display them all, overpowering the reader with irrelevance.

  • which format to use: the choice between text and table, table and chart, bar and pie.

  • how to use the technology effectively: computer software generates graphs easily, but the results hide your point behind incomprehensible chartjunk.

  • how to explain the information: selecting the right words for titles, columns and captions.

Plain Figures is a partnership between Sally Bigwood, located in Wakefield, Yorkshire, UK, and Melissa Spore, who divides her time between Toronto and Saskatoon, Canada. Sally and Melissa are sisters and both have dual citizenship in the United States. PlainFigures.com See all Topics

Labels: , ,


<Doug Klippert@ 3:02 AM

Comments: Post a Comment

  Wednesday, July 08, 2009 – Permalink –

Polyglot Polynomials

ToolPak Translator


I was disappointed recently when I tried to look up Eric Desart's ToolPak translator. I found his site "niet beschikbaar."

I won't use the boy and wet thumb story, but Ron de Bruin did spring up to save the day and make the download available.


"Ever wanted an oversight of the Analysis-ToolPak Add-In functions, their descriptions, their arguments, their VBA and Procedure names, and all of this in your LOCAL language including translations versus the corresponding English names?

This utility extracts this data from your LOCAL MS Excel edition.

As such this table can be generated for ANY LANGUAGE EDITION of MS Excel, even when this language is not yet integrated in the utility."


Analysis ToolPak Translator




See all Topics

Labels: ,


<Doug Klippert@ 3:03 AM

Comments: Post a Comment