Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > microsoft.public.excel.programming > #108702

Re: Can't find project or library

From "Peter T" <askformy@gmail.com>
Newsgroups microsoft.public.excel.programming
Subject Re: Can't find project or library
Date 2016-04-05 13:55 +0100
Organization A noiseless patient Spider
Message-ID <ne0cdl$qi6$1@dont-email.me> (permalink)
References (4 earlier) <ndupbu$5al$1@dont-email.me> <nduqt9$9tc$1@dont-email.me> <ndusvs$fuv$1@dont-email.me> <nduv1a$lnf$1@dont-email.me> <bb8f8656-6427-4e9f-ab02-f5127e3d9593@googlegroups.com>

Show all headers | View raw


"hbj" <hakan.bjorkstrom@gmail.com> wrote in message >
> Interesting!
> After opening all the ADO libs and getting the error meg, they're all
> now listed in References (even 6.1)!!! weird...
>
> -- 
> Garry
>
> Free usenet access at http://www.eternal-september.org
> Classic VB Users Regroup!
>   comp.lang.basic.visual.misc
>   microsoft.public.vb.general.discussion

"
Peter, I use Windows 7 Enterprise 32-bit and Office 2007 Pro. At the moment 
VBA requires (MISSING) "Microsoft ActiveX data Objects 6.1" located in 
C:\Program Files (x86)\Common Files\System\ado. (msado15.dll) One version of 
msado15.dll locates in "Program Files\..." but is that a correct dll? Which 
version should I use and where can I find teh correct version?
"

It might be 6.1, though msado15.dll is also 6.0 and 2.8 as there's nothing 
new in terms of public methods. Right click it, Properties, Details and look 
at File version and Product version. Try removing the MISSING reference, 
then browse to your msado15.dll and see if you can add it.

BTW your Win7, is that SPI? If so maybe the dll is not fully installed. If 
not SPI your dll is probably 6.0. Apart from that maybe there's something in 
common in your setup with what Garry described which I can't replicate.

As I mentioned before, consider coverting your project to Late Binding.

Peter T




Back to microsoft.public.excel.programming | Previous | NextPrevious in thread | Next in thread | Find similar | Unroll thread


Thread

Can't find project or library hbj <hakan.bjorkstrom@gmail.com> - 2016-04-04 04:17 -0700
  Re: Can't find project or library isabelle <i@v.invalid> - 2016-04-04 07:36 -0400
  Re: Can't find project or library GS <gs@v.invalid> - 2016-04-04 12:47 -0400
    Re: Can't find project or library hbj <hakan.bjorkstrom@gmail.com> - 2016-04-04 12:11 -0700
      Re: Can't find project or library GS <gs@v.invalid> - 2016-04-04 15:52 -0400
        Re: Can't find project or library "Peter T" <askformy@gmail.com> - 2016-04-04 23:24 +0100
          Re: Can't find project or library GS <gs@v.invalid> - 2016-04-04 18:50 -0400
            Re: Can't find project or library "Peter T" <askformy@gmail.com> - 2016-04-05 00:26 +0100
              Re: Can't find project or library GS <gs@v.invalid> - 2016-04-04 20:00 -0400
                Re: Can't find project or library hbj <hakan.bjorkstrom@gmail.com> - 2016-04-05 05:17 -0700
                Re: Can't find project or library "Peter T" <askformy@gmail.com> - 2016-04-05 13:55 +0100
                Re: Can't find project or library GS <gs@v.invalid> - 2016-04-05 09:41 -0400
                Re: Can't find project or library "Peter T" <askformy@gmail.com> - 2016-04-05 15:59 +0100
                Re: Can't find project or library hbj <hakan.bjorkstrom@gmail.com> - 2016-04-05 10:49 -0700
                Re: Can't find project or library "Peter T" <askformy@gmail.com> - 2016-04-05 19:15 +0100
                Re: Can't find project or library hbj <hakan.bjorkstrom@gmail.com> - 2016-04-05 11:48 -0700
                Re: Can't find project or library "Peter T" <askformy@gmail.com> - 2016-04-06 11:50 +0100

csiph-web