List of existing files

[Hatye]

Hi,

I would like to list all files in a specified folder. The files are placed in the following folder: "\\nodc01\ssa\Utstyr\Dokumenter\" & Me.Internnr" so that it will show different file content depending on what's selected/opened.
I have inserted a list and added this code (found here: Access/VBA Tutorials - List files recursively) to an event procedure:

Private Sub FilListe_Enter()

Dim strURL As String
strURL = "\\nodc01\ssa\Utstyr\Dokumenter\" & Me.Internnr


Call ListFiles(strURL, , , Me.FilListe)


End Sub

...but it doesn't work!
The error code says "Compile error: Sub or Function not defined".

Can anyone please help me with this?

 

[Joe4]

Did you add the ListFiles function code from that link to?
Otherwise, you are trying to call something which does not exist!

 

[Hatye]

Did you add the ListFiles function code from that link to?
Otherwise, you are trying to call something which does not exist!

Hi and thank you for your reply!

Yes, but I had made some stupid mistakes in some of the paths..

I have two other questions I hope that you or anyone else can help me with:
* Is it possible to hide the path of the file, so that only the file name is shown?
* Is there a way to open files in this list? It is not possible by double clicking, and when I right click the files, it is only copy, cut, paste and so on that are shown..