LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 65
Default Strange error message when loading a collection with an item ofuserdefined type

Hi aflatoon,

thank you very much, that worked! Now I can start struggling with all
the other problems concerning the UDT-to-Class migration ;) thanks
again,

Best Regards

deltaquattro

On 15 Mar, 14:56, aflatoon wrote:
Hello,
I think your problem is that you cannot coerce the UDT to a Variant to
pass to the Add method. You may as well create your own Record class
rather than using a UDT and pass an instance of that to the collection
instead.
HTH.

--
aflatoon
------------------------------------------------------------------------
aflatoon's Profile: 1501
View this thread:http://www.thecodecage.com/forumz/sh...d.php?t=187568

http://www.thecodecage.com/forumz/chat.php


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error in loading DLL message אלי Excel Programming 0 October 22nd 07 07:00 AM
Strange Type Mismatch Error #13 john431 Excel Programming 2 October 19th 07 11:02 PM
type mismatch error when passing collection byRef Tara H Excel Programming 2 September 14th 07 05:56 PM
Collection::Item runtime error PaulH[_2_] Excel Programming 6 August 27th 07 09:03 PM
Strange data type error johnsday Excel Programming 7 January 20th 06 04:08 PM


All times are GMT +1. The time now is 01:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"