Post a reply

Options
Add an Attachment

If you do not want to add an Attachment to your Post, please leave the Fields blank.

(maximum 10 MB; please compress large files; only common media, archive, text and programming file formats are allowed)

Options

Topic review

lcao

How can I define EnumerateOptions in VBA

hi, there. How can I get the file list by filtering file name starting with something,say Report_?
I was thinking about using EnumeratFiles, but I can not define EnumerateOptions by the way below. please shred some light on it?


Dim remotePath As String
Dim mark As String
mark = "*.zip"
remotePath = "uat/download/"
Dim remotefile As New RemoteFileInfoCollection
Dim options As New EnumerateOptions
Set options = EnumerateOptions_None
Set remotefile = mysession.EnumerateFiles(remotePath, mark, options)