Set objFSO = CreateObject ("Scripting.FileSystemObject") Set objFolder = objFSO .GetFolder("D:\testing folder") For Each objFile In objFolder.Files MsgBox Cstr(objFile) Next In my folder there are so much files but i want only excel files in that folder .Please suggest some idea to solve the problem.

Have you tried objFile.GetExtension() ?? If objFile.GetExtension() "xlsx" Then objFile.delete() End If

Shall you brief it? I dont use that

Answers

I want some Extension of file from a selected folder in VBA?

Dinesh Santhalingam

821

In my folder there are so much files but i want only excel files in that folder .Please suggest some idea to solve the problem.

Next Recommended Forum

How to convet plural word to singular word from textfile?

Forum Statistics

Please welcome our newest member Stephin SR.
3,090,215 users have contributed to 147,410 threads and 483,568
In the past 24 hours, we have 7 new threads, 20 new posts, and 86 new users.
In last week, the most popular thread is 'Will LOV111VOL replace SharePoint worldwide?'.

Upcoming Events

View all