Hello!
This is my first post (of many, I think).

I need to create code in VB and I am really only familiar with VBA (Excel).
I was wondering if the following code (which is taken from the sample examples in Excel's Help files) would work in a regular VB application (and if not, what the equivalent code might be for accomplishing the same task using VB).

Thanks in advance for any help.

T

Well, do you have the code you want us to look at? The code should work for the most part. But you may need to reference specific libraries depending on what you are trying to do.



Larry Asher

Oh, right. The code DUH!!!
Sorry about that
My first post AND my first screw-up (well at least I got that out of the way) :D

Here is the code :

Set fs = Application.FileSearch
With fs
    .LookIn = "C:\My Documents"
    .FileName = "*.doc"
    If .Execute(SortBy:=msoSortbyFileName, _
            SortOrder:=msoSortOrderAscending) > 0 Then
        MsgBox "There were " & .FoundFiles.Count & _
            " file(s) found."
        For i = 1 To .FoundFiles.Count
            MsgBox .FoundFiles(i)
        Next i
    Else
        MsgBox "There were no files found."
    End If
End With


Thanks again!

i think this is a VBA specific code..i cant remember having seen the FileSearch method in VB