Re: Excel and variants

I guess you should test whether the $dateVar is a reference before you try to call the ChangeType(). This should be enough:

$dateVar = $dateVar->ChangeType(VT_BSTR)->Value() if (ref $dateVar);
[download]

You should also add a few eval {} blocks into your code and handle the exceptions gracefully.

Jenda
Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live.
-- Rick Osborne

Edit by castaway: Closed small tag in signature

Comment on Re: Excel and variants Select or Download Code

Replies are listed 'Best First'.
Re: Re: Excel and variants by Anonymous Monk on Oct 24, 2003 at 16:19 UTC
That's the stuff I needed, thanks Jenda. Michael	[reply]