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

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

Re: Can't find project or library

Show all headers | View raw

"hbj" <hakan.bjorkstrom@gmail.com> wrote in message
On Tuesday, April 5, 2016 at 5:58:57 PM UTC+3, Peter T wrote:
> "Peter T" <askformy@gmail.com> wrote in message >
> > "
> > 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.
>
> If you can't, simplest might be just to reinstall 6.1
> https://support.microsoft.com/en-us/kb/2640696   x86 for Win7
>
> You may need to remove and re-add the reference
>
> Peter T

"
SOLVED!
Thank you!

I found 2 files msado15.dll, one created 2009 and one 2010, neither of those 
accepted. I simply changed to ado28 which was listed in available reference 
list.
"

Sure, the 2.8 would most likely work or even 2.5, but why not install the 
6.1 (via the link above)

"What I'm still wondering, how on earth VBA engine complains about ADO in a 
statement with common command TRIM(....)? "

Whenever there are any MISSING references String and DateTime functions are 
particularly likely to fail unless fully qualified to the respective 
library, eg
VBA.Strings.Trim()

Keep in mind if your file is ever loaded on a system without the 2.8 it will 
fail again. Late Binding would usually avoid these problems.

Peter T 

Back to microsoft.public.excel.programming | Previous | Next — Previous 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