create directory list

  • Thread starter Thread starter JP%$
  • Start date Start date
J

JP%$

I have a folder that has dwg files in it and I would like to organized by
last 2 digit of file name, any suggestions?
 
I have a folder that has dwg files in it and I would like to organized by
last 2 digit of file name, any suggestions?

Would you like to do so in an Access Database (the subject of this newsgroup)?
If so you can indeed do so with the help from a little bit of VBA code. You
could create a Table with a Text field for the filename, and perhaps a second
indexed field for the last two characters. Make this an Integer field if the
last two digits are in fact digits, Text if they are alphanumeric.

You can then use VBA code using the Dir() function to retrieve the filenames
from Windows and store them i
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top