Opening file and extracting file name and filepath

**kenadams378** · 11-06-2013, 04:37 AM

I have the following code that takes the file name & filepath and populates cells with the data but for some reason this one won't work, it will populate the filename but not the filepath.

Any ideas??

Please Login or Register  to view this content.

**TMS** · 11-06-2013, 05:32 AM

Looks like you're making hard work of that. Why not just use:

Please Login or Register  to view this content.

Regards, TMS

**kenadams378** · 11-06-2013, 06:34 AM

Thanks, where would i add the cells i need the data in?

**TMS** · 11-06-2013, 06:51 AM

where would i add the cells i need the data in?

Where you are putting it now?

Please Login or Register  to view this content.

Note that you'll only get a path for a saved workbook. Could that be why you're not getting what you expect. And your code appears to be working on the File Name which wouldn't have any "\"s in it as that's a Path Separator and would only appear in the Path or FullName properties.

Regards, TMS