ActiveXLS

Excel as a database, Part 2

Neopoleon : Excel as a database
“As a developer, you’ve probably, at some unfortunate point in your life (possibly several points, actually), been handed an Excel file that has been crammed full of “data” by someone in marketing and told to “do something with it.”"

1 comment November 8th, 2006

VBA Code Cleaner

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

Add comment October 25th, 2006

Top 10 Signs That You Purchased a Bad Spreadsheet

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

Add comment October 25th, 2006