VBA Code to get file names with path

[Liz_Biz]

Hello Friends,

I need a code to get all excel file names in a folder. File names should be like full names as "C:\Users\Vikas'\Desktop\Mail Macro.xlsx" .

Please let me know in case of any concern.

Thanks,
Liz.

[Alf]

Perhaps like this?

Please Login or Register  to view this content.

Looking at your folder I'm not really sure of the full folder name. Does it stop at "Desktop" or is it Desktop\Mail?
If so change sPath to "C:\Users\Vikas'\Desktop\Mail\" and make the same chamge in fName.


Alf

[Liz_Biz]

Hi Alf,

Thank you so much for looking into this.

Code is working as expected. This need a little add on.I have tried but failed.

Is it possible that code will ask user to enter folder path ? Ex. Code will ask for "C:\Users\Vikas'\Desktop\"


Thanks,
Liz

[apo]

Here's another..

Please Login or Register  to view this content.

[Alf]

Hi apo

Nice code and this is the right answer the question Liz didn’t ask in her first post.

I'm a bit puzzled by this part

Please Login or Register  to view this content.

I thought this would only find ".xls" files but it finds ".xlsx" and "xlsm" as well. Would you care to explain?

Alf

[apo]

Hi Alf..

I am not sure of the technical reason why.. but if you go to the Command prompt and type Dir *.xls when in a directory that has xls/xlsx/xlsm files.. it will list them all..

I originally posted the code and workbook without the wildcard after the xls.. but then changed it (thinking i needed to) .. but like you say.. it is actually not needed..

[Alf]

Thanks for feed back. This seems to be another case of "Excel moves in myserious ways its miracles to preform"

Alf

[apo]

You got me thinking... so i did some gooogling...

Here are some interesting discussions on it..
http://www.mrexcel.com/forum/excel-q...lsx-files.html

http://www.pcreview.co.uk/forums/dir...-t1628303.html

btw.. thanks for the rep points..

[Alf]

So it's back to basic sorry DOS of course.

Well this is good to know since writing macros looking for excel files with specific formate is not that unusual.

Alf

[Liz_Biz]

Thanks Alf & Apo. I got my solution but can't mix it in my mind. Thank you so much.

[Alf]

Hi Liz

Thanks for feed back and rep.

Alf

[Liz_Biz]

Hi..

I had a quick look at it..

Are you saying you want to Select a File via a File Dialogue and then the code will show all files within the folder(meaning the folder that contains the selected file) with file paths shown..?

But.. more importantly... I would like you to post these further questions in the existing thread you made (rather than via PM).. this helps others looking for the same kind of solution in time to come...

Hi Apo,

Here is my query.

I want to select file(s) via dialog box and get path for that only and not for all files in that folder.

It may be more than one.

Thanks,
Liz

[apo]

Try this...

Change the InitialFilename path to suit..

Please Login or Register  to view this content.

[Liz_Biz]

Apo,

This is working as expected but its pasting path in cell (1,1). I need this in cell (2,6).

Also, If I run it 2nd time, its pasting data from first cell again not from the last blank cell of 6th column.

I know, I am giving you more trouble, but please help me. It can save my neck.

Thanks,
Liz.

[apo]

You only need to change this:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

[Liz_Biz]

Excellent !! You helped me a lot. Thank you so much!!!

[Liz_Biz]

Thanks!!! Excelforum.com!!!