December 2007 - Daily Dose of Excel

Daily Dose of Excel

Home

Syndication

News

This site is published here by kind permission of Daily Dose of Excel's owner Dick Kusleika

Archives

Sort by: Most Recent | Most Viewed | Most Commented

Terminating Dependent Classes

I have four objects that are all dependent on each other. They are CInvoice has many CInvoiceLines, CInvoiceLine has many CRoyaltyLines, CRoyaltyLine has many CRoyaltyAdjustments. In order to properly terminate all of these class modules, I need to remove any and all dependencies. If I don't, the classes will stay alive and [...]

Published Fri, Dec 28 2007 5:23 PM by Daily Dose of Excel

Filed under: Classes, VBA Advanced
Page update: Copy a range from closed workbooks (ADO)

Hi all I update my ADO page today. http://www.rondebruin.nl/ado.htm The code is also working in Excel 2007 now (Excel 2000-2007). I use Late binding now to avoid private mails like "It is not working" When you use the Subfolder option in Example 7 it will loop through all files in all levels below the rootfolder. If you have problems or suggestions [...]

Published Sun, Dec 23 2007 11:12 AM by Daily Dose of Excel

Filed under: General, Excel12
Fixing Help

It seems to be universally understood that Help in Office products gets worse with every release. I'm still using 2003 almost exclusively, but I haven't heard anyone shouting from the roof tops about the improvements in 2007's Help. I've been thinking about help in general and what makes a good help system. Leaders in [...]

Published Fri, Dec 21 2007 4:21 PM by Daily Dose of Excel

Filed under: General
Google Toolbar Slows Excel

This report comes from Charles Williams of DecisionModels.com fame. Charles knows a thing or two about performance in Excel. For the last few weeks I have been trying to find out why clearing a large range of cells caused Excel to hang on some PCs but not on others. This does not happen with Excel [...]

Published Tue, Dec 18 2007 5:46 PM by Daily Dose of Excel

Filed under: Bugs
Catching Paste Operations

You know the situation: You have carefully setup a workbook with intricate Validation schemes. But then along comes your user and he copies and pastes at will. Result: Validation zapped, workbook structure violated. What to do? The only way I find to be reliable is to catch all possible paste operations. But this isn't very easy, [...]

Published Mon, Dec 17 2007 2:27 PM by Daily Dose of Excel

Filed under: Classes, CommandBars, Collections, Copy and Paste, VBA, MVP, Events, Data Validation, Downloads
Donut Selection

This one really hits home: Click image for larger view.

Published Fri, Dec 14 2007 9:11 AM by Daily Dose of Excel

Filed under: Links
VBA Code Documenting Tools: Project Analyzer and Visustin

Every VBA developer (which is anyone who knows how to get into the VBE I guess) develops his or her own programming habits: sparse commenting or elaborate commenting, naming convention (or no declaration at all), code indenting, preference for certain structures and methods over others. You name it. Many books have been written about this, [...]

Published Thu, Dec 13 2007 3:58 AM by Daily Dose of Excel

Filed under: VBA Advanced, VBA, MVP
Office 2007 SP1

Via the US ISV Developer Team Blog Microsoft Office 2007 SP1 will be available for download Dec 11. The improvements in 2007 Office System SP1 are in response to direct feedback from power users at large organizations or indirect feedback from home and Office users through the Dr. Watson bug-reporting system. I haven't seen any details about [...]

Published Sun, Dec 09 2007 10:27 PM by Daily Dose of Excel

Filed under: Excel12, Polls
Google Chart API

This is the coolest thing I've seen in a long time: Google Chart API. The Google Chart API returns a PNG-format image in response to a URL. Several types of image can be generated: line, bar, and pie charts for example. For each image type you can specify attributes such as size, colors, and labels. [...]

Published Fri, Dec 07 2007 11:40 AM by Daily Dose of Excel

Filed under: General
Borders All Around

I was reading How to Win at Monopoly (via Kottke.org). On Table 1, a range of cells was outlined. Strangely (or maybe not so strangely), I thought about the most efficient way to do that in Excel. I don't think there is one. Let's say I hold down the control key and select [...]

Published Tue, Dec 04 2007 8:56 AM by Daily Dose of Excel

Filed under: VBA
ExcelRefTool; A New Formula Auditing Tool

Hi, A while ago I requested beta testers for a new utility, now called "ExcelRefTool". Thanks to my beta testers, the tool is now mature enough to be exposed to the general public. Have a look here, download the demo if you like and give it a spin. And thanks again, to everyone who took the trouble of beta [...]

Published Mon, Dec 03 2007 8:53 AM by Daily Dose of Excel

Filed under: General, MVP, Downloads, Formulas, COM Addins, Add-ins

December 2007 - Daily Dose of Excel

Syndication

Recent Posts

Tags

News

Archives

Terminating Dependent Classes

Page update: Copy a range from closed workbooks (ADO)

Fixing Help

Google Toolbar Slows Excel

Catching Paste Operations

Donut Selection

VBA Code Documenting Tools: Project Analyzer and Visustin

Office 2007 SP1

Google Chart API

Borders All Around

ExcelRefTool; A New Formula Auditing Tool