Hi,

Does anybody know what syntax to be used in opening multiple file in VBA ms access and store the file path?

Normally what I do inside MS excel vba is by using:

Code:
files = Application.GetOpenFilename("Excel Files (*.xls), *.xls", , , , True)

For i = 1 To UBound(files)

next i
I need this one coz I need to select multiple files (ex. xl,txt)

Thanks