archives

Date
  • 01
  • 02
  • 03
  • 04
  • 05
  • 06
  • 07
  • 08
  • 09
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31

Pass a Function as a Parameter in VBA

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

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

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).

  1. 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

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).

  1. 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

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: