Archive for October, 2006
“Why do people keep putting data in spreadsheets that obviously belongs in a database? Oddly enough, part of the reason came to me in a fairly unlikely place, reading to my kids before bed. We had just plopped on the couch to read a book when my kindergartener made me back up and read the cover of the book, pointing out to me the author and the illustrator. That was an enlightening moment; from a very early age we start learning the structure of documents. Title, author, and date of publication, page number, etc, etc is reinforced at every grade level.”
This article points out one major mistake that most users do when using spreadsheets: mistaking them for a database.
Document Centric
October 31st, 2006
Contextures.com shows how you can display different images based on an cell value input. Via DashBoardSpy
October 31st, 2006
The course can be completed in one day, or over four separate sessions. Content includes four 75 minute lectures and four 30 minute labs. The actual time needed to complete the labs may vary, depending on the attendees’ programming experience.
Graduates will have a good high-level understanding of the new capabilities of .NET 3.0, and are welcome to take the content and re-present it to their peers, in either an official or unofficial capacity.
.NET U
October 26th, 2006
Excel has the ability to put code in three places. If the code is in a standard module the key to stopping the dialog is to remove the entire module(s), not simply delete the code in it. To do this:
- Open the VBE (Alt+F11)
- In the project explorer look for the name of the workbook. Below this you should see a folder called …
Read the rest at Nick Hodge
October 25th, 2006
This utility Decompiles and Compacts VBA code saved by Excel or Word, reducing the file size and the compilation conflict probability between different Office versions while also cleaning compilation garbage accumulated during the project phase that frequently generates errors and slows loading.
Useful for developers before file delivery and also for end users who experience problems when loading 3rd party VBA projects, because this utility can clean these projects without unprotecting the VBA project, from the closed file on disk and opened in an application environment free of the influence of add-ins, COM add-ins, and others pre-installed projects.
from ORLANDO’s VBA and EXCEL SITE
October 25th, 2006
During the process of creating VBA programs a lot of junk code builds up in your files. If you don’t clean your files periodically you will begin to experience strange problems caused by this extra baggage. Cleaning a project involves exporting the contents of all its VBComponents to text files, deleting the components and then importing the components back from the text files.
VBA Code Cleaner provides:
- The ability to strip comments, blank lines and spaces from your code
- The ability to retain the exported code files
- The ability to choose the locations to which backup files and exported code files are saved
- The ability to save all settings for each project you clean so that each time you clean a project the code cleaner will be preset for it
October 25th, 2006
10. A sticker on the box reads, “Now Supports DOS 1.2″
9. It is part of a software suite called “Office Schmoffice.”
8. User testimonials on the box are written in Arabic.
7. The help file consists of three words: “Don’t ask me.”
6. The Setup diskette reads, “Disk 1 of 1″.
5. The Setup routine displays “Another Sucker” as the default user name.
4. The user manual is scribbled on the back of an old envelope.
3. The technical support phone number is 555-1212.
2. The only way to get a hard copy of your work is to photograph the screen.
1. When you press F9, a message box tells you to dig out your calculator.
via TheSpreadsheetPage
October 25th, 2006
“MicroCharts enhances Microsoft Excel and Microsoft Analysis Server with sparklines, bullet graphs and other in-cell charts.”
Great add-in, via DashBoardSpy
October 25th, 2006