get list of folders in a directory

[plans]

Hi,

I have MyDirectory defined as follows:

Please Login or Register  to view this content.

I am trying to get a MsgBox with a list of the folders within the "JOBS" folder (no need to list subfolders).

Please advise.
Thanks

[michson]

Please Login or Register  to view this content.

[plans]

Hi michson,
I tried your code, but when I run it, nothing happens.
FYI
Thanks

[shg]

Look in the Immediate window; do Ctrl+G if it's not visible.

[plans]

shg,
Yes it is there.
Thanks

[shg]

You're welcome.

[kev_]

To get your message box listing the folders, build a message string like this

Please Login or Register  to view this content.