Hi,

I have a folder or directory, which has many excel files as well as pdf ones.

I wish to run a procedure that would open and read the data of only Excel files and skip the pdf one.

I can use "On Error Resume Next" but this slows the process because VBA still open pdf. As an alternative I wrote this: Dir(FilePath & "\*.xls*") but VBA ignored or skipped all files, I think, because the extension is hidden.

Can someone please advise how to deal with this?

Thanks

Hi Khalil

Can you please try this

http://vbadud.blogspot.in/2006/12/di...ual-basic.html

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)