Set objFSO = CreateObject (Scripting.FileSystemObject) Set objFolder = objFSO .GetFolder(D: esting 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

273

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.

Answers (2)

Next Recommended Forum

how create a temp folder

Leaderboard

View all

Baibhav Kumar

Shivam Payasi

Reshab Kumar Singh

View all

Yesterday's leader

HTML, CSS, JavaScript, Bootstrap, Wordpress, Python, Java, C, C++, BigData, MongoDB, MySQL, Blazor, .Net, Linux, AS

Gurugram (India)

Member of the month

Chennai (India)

Speaker of the month

C#, .NET

Chitrakoot (India)

Upcoming events

View all

Suggested for you

View all

Daisy Princess

Mahesh Chand

Shivam Payasi

Alistair Cook

Forum Statistics