archives
Pass a Function as a Parameter in VBA
Submitted by Kevin Kleinfelter on Fri, 2009-10-30 13:19.I've been doing some programming in Excel's VBA recently. I have a series of blocks of code, where the only thing different in the blocks is that each block calls a different function. Pseudo-code resembles
blah1 blah2 Call Function1 blah3 blah4 ... blah1 blah2 Call Function2 blah3 blah4 ... blah1 blah2 Call Function3 blah3 blah4 ...
Automation Error - The object has disconnected from its clients
Submitted by Kevin Kleinfelter on Mon, 2009-10-26 19:16.Here's a non-intuitive error from Excel.
run-time error '-21474417848 (80010108)' Automation Error - The object has disconnected from its clients'
I was getting this on a call to QueryTables.Add.Refresh. Sometimes I also received out-of-memory errors and sometimes Excel 2003 simply crashed.
Wiki Links in Evernote
Submitted by Kevin Kleinfelter on Fri, 2009-10-16 14:25.I'd really like to be able to link from one Evernote note to another, but Evernote doesn't have this feature (yet).
Here's an idea for grafting wiki words onto Evernote (without access to the source code).
- Register a custom URI handler per http://msdn.microsoft.com/en-us/library/aa767914%28VS.85%29.aspx. I'd probably register "en:".
Wiki Links in Evernote
Submitted by Kevin Kleinfelter on Fri, 2009-10-16 14:24.I'd really like to be able to link from one Evernote note to another, but Evernote doesn't have this feature (yet).
Here's an idea for grafting wiki words onto Evernote (without access to the source code).
- Register a custom URI handler per http://msdn.microsoft.com/en-us/library/aa767914%28VS.85%29.aspx. I'd probably register "en:".
Focus Problem With NVIDIA nView Desktop Manager
Submitted by Kevin Kleinfelter on Fri, 2009-10-02 20:19.One feature provided by NVIDIA nView Desktop Manager is that it can add some icons to your title bar (just to the left of the minimize/restore/close buttons) to support window roll-up, move-to-next-display, and maximize-across-multiple-displays.
However, when you enable these, you can wind up with some obscure focus problems:
