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