Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
rather than tinker around for hours trying to figure how
to get this expression to work, i was hoping that someone with more experience could show me how its done. I want the message to say "Found files blah blah blah...:" then list each file it found below, each file found getting its own line in the msgbox. my method below has multiple syntax errors that i havnt been able to get around: MsgBox("Found File '" & .Filename & "' with " & .FoundFiles.Count & " file(s) in it." & Chr(10) & _ For i = 1 To .FoundFiles.Count .FoundFiles (i) & Chr(10) Next i & _ Chr(10) & "Would you like to save in the file?", vbYesNoCancel + vbExclamation, "Existing File Found") |