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

Re: Can't find project or library

From	GS <gs@v.invalid>
Newsgroups	microsoft.public.excel.programming
Subject	Re: Can't find project or library
Date	2016-04-04 15:52 -0400
Organization	A noiseless patient Spider
Message-ID	<ndugfl$v50$1@dont-email.me> (permalink)
References	<7428ef6c-a205-4e41-8b6d-0782551c8c87@googlegroups.com> <ndu5lb$gbd$1@dont-email.me> <71baaa6c-546b-4337-b4ab-c0ebd407167b@googlegroups.com>

Show all headers | View raw

> On Monday, April 4, 2016 at 7:47:48 PM UTC+3, GS wrote:
>>> Often the macro stops at an undefined variable, when i "Dim" the 
>>> variable macro continues.
>> 
>> Variable declaration should set to 'Required' just as a *best 
>> practice*. This can be set on the Editor tab of the VBE Options 
>> dialog...
>> 
>> -- 
>> Garry
>> 
>> Free usenet access at http://www.eternal-september.org
>> Classic VB Users Regroup!
>>   comp.lang.basic.visual.misc
>>   microsoft.public.vb.general.discussion
>
> Yes Garry I know ;)
>
> I got the file into a state I can see what libraries are missing: ADO 
> Library 6.1. I downloaded it from MS website but it wouldn't install. 
> Reads something like "Searching for updates on this computer".
>
> Håkan

You could change your ref to whatever version was installed with your 
OS. This Win7 Pro machine, for example, has Microsoft Active Data 
Object 2.5 installed. Don't know what ADO Library 6.1 is but sounds (by 
its name) 3rd party. Better, IMO, to stick with intrinsic libs 
otherwise every machine using your project will need the 3rd party lib 
as well. (Bit of a PITA, no!)

-- 
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
  comp.lang.basic.visual.misc
  microsoft.public.vb.general.discussion

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