Re: VBA/VB6 Collection Type Mismatch

Hi Jake,

It would also help, when you ask a question, to tell use the version of
WORD involved in the problem... If, for example, this were Word 97 in
combination with VB6 then there could very well be a problem, as Word
97 uses VB5, not 6.

> I call a VBA function in a Word template from a VB6 application,
> passing a Collection as an argument to the function. This works well
> in most cases, except a couple of rogue machines. On just one or two
> machines, I get a "Type Mismatch" error when attempting to call the
> function.
>
> It looks to me like the VBA collection object on these machines does
> not match the VB6 collection object. Is this possible? Can anyone
> suggest a way to fix the problem?
>

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail :-)

.

Relevant Pages

  • VBA/VB6 Collection Type Mismatch
    ... I call a VBA function in a Word template from a VB6 application, ... except a couple of rogue machines. ... It looks to me like the VBA collection object on these machines does ...
    (microsoft.public.office.developer.vba)
  • Re: Returning a Collection object from .NET to VB6 (using COM Interop)
    ... And it fails on that Set statement with the "Type Mismatch". ... So I changed the VB6 code to the following: ... > Hashtable to a more-vb6-friendly Collection object instead. ... so I can work with the data from my Hashtable/Collection from VB6? ...
    (microsoft.public.dotnet.languages.vb)
  • Re: memory requirement for DotNet 2005?
    ... Three year old machines today can still be used for VS.NET ... > towards the current/future hardware. ... > hardware, for example, VB6. ... As far as replacing machines every 3 years, that's quite simply a waste of money for most ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Register TLB
    ... But I get the error 429 on the deployed machines. ... the problem might in its inability to find the associated .dll file. ... PackageDeploymentWizard in vb6, if only it could understand the ... There didn't seem an option for generating a dependency file in vb.net, ...
    (microsoft.public.vb.general.discussion)
  • reading a VB6 Collection object in C#
    ... I'm working on a project that uses some older VB6 COM objects. ... the classes returns a Collection object, which I am having trouble ... reading in C#. Can someone point me in the right direction here... ...
    (microsoft.public.dotnet.framework.interop)