Loop around files in a folder

[PizMac]

I would like to code a procedure that (given a known folder name):-

loops around a routine which
imports file beginning with "xyz" (of indeterminate types)
appends file to a combined table
moves said file to sub-folder (named archive)

the import (once I know the file name) and append I don't have a problem with, and I think I can work out the move - any help appreciated on a loop around the file directory listing and getting the file names that exist

Thanks
Judith Pizer

 

[KenReay]

Hi

See Dir() in help

something like:

Filename = Dir("xyz*")
Do Until Filename = ""
' do whatevwer with file name
filename = dir()
Loop

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK