Find a File

[Simon]

Hi,

I want ask you that, how can i find a file ? e.g.(c:\test\test.txt")

Thanking you in advance for your collaboration.

 

[Tom van Stiphout]

On Wed, 20 Jan 2010 05:13:01 -0800, Simon

Find? What do you mean?
You can test if this path points to a file using the Dir command.
Check it out in the help file.

-Tom.
Microsoft Access MVP

 

[Stefan Hoffmann]

hi Simon,

I want ask you that, how can i find a file ? e.g.(c:\test\test.txt")

Use either the VBA built-in Dir() function or use the FileSystemObject:

http://www.techbookreport.com/tutorials/fso1.html
http://support.microsoft.com/kb/186118

You need to either set a reference on the MS Scripting library or use
late binding.

http://www.dicks-clicks.com/excel/olBinding.htm


mfG
--> stefan <--

 

[Daniel Pineault]

see http://www.mvps.org/access/api/api0006.htm
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.