OS question

[khushbu.bhandari]

Is there a possibility to get details of folder contents/no.of files in a particular folder on the Operating System.

Can this information be captured on Excel or DOS Command Prompt?

 

[VoG]

This will list the Excel files in a folder

Sub ListFiles()
Dim MyFolder As String
Dim MyFile As String
Dim j As Integer
MyFolder = "C:\example"
MyFile = Dir(MyFolder & "\*.xls")
Do While MyFile <> ""
    j = j + 1
    Cells(j, 1).Value = MyFile
    MyFile = Dir
Loop
End Sub

 

[khushbu.bhandari]

After writing this Macros, Where does the information captured.

I copied this macro and added the drive MyFolder = "C:\example"

Another thing i keep getting an error message stating that the Run Time error '5'- Invalid Procedure or call argument

 

[xenou]

You must have a folder called example on your C: drive. The output is to the cells in a worksheet (VoG's code, by the way, looks for excel files with xls extensions, not all files).
Macro basics here (among other tutorials to be found on the internet):
http://www.anthony-vba.kefra.com/vba/vbabasic1.htm

Can this information be captured on Excel or DOS Command Prompt?

Output to a command prompt requires no vba. Just type dir at the command prompt.

Listing files in a folder is a common request and you'll finding many examples with a little searching on google.
This one seems good and has a training video and detailed instructions:
http://excelexperts.com/VBA-Tips-List-Files-In-A-Folder

ξ