VBA Open Specific File Type

[hobbiton73]

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

[davesexcel]

fPath = "XXXXXXXXXX"
is not a file path

[hobbiton73]

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

[davesexcel]

Can you attach a pic of the warning msg?

[hobbiton73]

Hi @davesexcel, forgive me but I'm not sure what a picture will show other than the error message. I can say though that debug does highlight this line as the cause:

Please Login or Register  to view this content.

.

Many thanks and kind regards

Chris

[davesexcel]

Show the darn file path, or a fake file path, who cares, I want to see how the file path looks.

[hobbiton73]

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

[JosephP]

getfolder gets a reference to a folder not a file-it oughta be

Please Login or Register  to view this content.

[hobbiton73]

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

[snb]

Please Login or Register  to view this content.

you can sort by name, by size , by time using the /o switch

[JosephP]

Chris
you oughta change the ListFilesInFolder routine so it checks the extension on the name of each file