>How would I modify this retrieve statement to open a file in a chosen directory
>say the directory I want to inspect is C:/MyDir/*.txt
>Without having to CD
>
>gcTableName = GETFILE('txt', 'Open Table:')
>
>thanks
>k

Apologies - Antonio lopes had answered this query for me last year - I just found it.

TRY
m.lcFilePath = LOCFILE("C:\backups\TP*.dbf","Table:DBF","Import Table:")
CATCH
m.lcFilePath = ""
ENDTRY

MESSAGEBOX(m.lcFilePath)