VBA/VB6 Collection Type Mismatch



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?

.



Relevant Pages

  • Re: VBA/VB6 Collection Type Mismatch
    ... combination with VB6 then there could very well be a problem, ... except a couple of rogue machines. ... > It looks to me like the VBA collection object on these machines does ... This reply is posted in the Newsgroup; ...
    (microsoft.public.office.developer.vba)
  • 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)
  • Re: Multi user application
    ... msadodc.ocx is a custom control installed most likely by VB6 application. ... machines and register the control using regsvr32.exe like so ... > All user are using Windows NT and to create the ODBC connection I had to ...
    (microsoft.public.data.odbc)

Loading