Working w/ long filename txt files

[Bob Barnes]

I have 12-character .txt (in CSV format) files..IE..050156031708, where
050156 is a Store, and 031708 is the date.

Planned to use this code to read data into an Access Table..
fname = Dir("C:\CEFiles\*.*")
While Len(fname)
' do your stuff
fname = Dir()
Wend

Have heard there's a way to work w/ .txt filenames longer than 8-characters.
Is there?

TIA - Bob

 

[Douglas J. Steele]

That code should work fine with long file names.

Have you tried it? What happens when you do?

 

[Bob Barnes]

Doug - I tested 2 files. The first ran fine, while the 2nd filename appeared
in a MsgBox as a null string. We decided to go w/ the 6-character Store name
as the filename. Each Store has semi-annual Inspections.

We're using Syware's Visual CE. So far..so good.

Thank you - Bob