VBA Open Specific File Type

Hi, I wonder if someone could help me please.

Using a source file I found here:http://www.learnexcelmacro.com/wp/20...d-sub-folders/, I've put together the following code which downloads a list of files when the workbook opens.

Please Login or Register  to view this content.

The problem I have is with this line:

Please Login or Register  to view this content.

where I'm trying to list a specific file type, but when I run the code I recieve a 'Path not found' error.

I know the fPath is correct, but I just wondered whether someone could point out where I've gone wrong on trying to download a specific file type.

Many thanks and kind regards

Chris

Hi @davesexcel, thank you for taking the time to reply to my post.

No it isn't but I didn't want to publish the real file path.

Kind Regards

Chris

Hi @davesexcel, please find a file path as you asked for.

fPath = "\\c\s\xxx\xxxxxx\xxxxxx\Dragon - Application-Specific Script Conversion 2014\Converted Scripts\Done\"

Kind Regards

Chris

Hi @JospehP, thank you for taking the time to reply to my post.

Thank you for the giuidance, but can you tell me please how I fetch a specific file type then.

Many thanks and kind regards

Chris