Connecting Tech Pros Worldwide Forums | Help | Site Map

Filesearch problem

Guest
 
Posts: n/a
#1: Nov 13 '05
Hi

I am using Filesearch to find a list of files in a directory, and then to
take the data and put it into an Access database. The code was working well
within VBA and I have ported it into VB6, and it no longer works.

Basically code is as follows:

Dim fsAllFiles as Office.Filesearch

Set fsAllFiles = Application.Filesearch

Here I get an Object Required error which I can't figure.

Any help appreciated.

Cheers

Kevin




pietlinden@hotmail.com
Guest
 
Posts: n/a
#2: Nov 13 '05

re: Filesearch problem


Kevin,
you probably do not have a reference to Office in your VB6 code, so the
libraries are not available.

You an use Dir() to do this, too.

Closed Thread


Similar Microsoft Access / VBA bytes