Get file name

[tax112]

Hi everybody.
I want to get the file name from the following code.

Please Login or Register  to view this content.

Who can help me.
Thank you.

[ByteMarks]

As you're using FSO, you could use this in your For X loop

Please Login or Register  to view this content.

[Logit]

The following will provide the file name. You can add the code to the end of your existing macro or
maintain it as independent. I correct my previous statement ... ByteMarks has indicated how to obtain
the file name.

Please Login or Register  to view this content.

[tax112]

As you're using FSO, you could use this in your For X loop

Please Login or Register  to view this content.

Please help me fully integrate it into the VBA code.

[tax112]

The following will provide the file name. You can add the code to the end of your existing macro or
maintain it as independent. I correct my previous statement ... ByteMarks has indicated how to obtain
the file name.

Please Login or Register  to view this content.

I want get the file name *.text, not the excel file.

[ByteMarks]

Here you go.

Please Login or Register  to view this content.

[tax112]

Here you go.

Please Login or Register  to view this content.

Still not what I mean.
What I mean is to get the *.text file name and assign it to a certain column in the Excel spreadsheet. For example, how to edit the code in column AA?

[ByteMarks]

I'm not quite sure what you mean, but maybe this to put the file name in column AA

Please Login or Register  to view this content.

[tax112]

@ByteMarks:
The key is in this line of code
Des.Offset(, 26).Resize(K) = sFileName
Thank you.

[Logit]

MsgBox at the bottom of the macro will get the file name ...

Please Login or Register  to view this content.

[tax112]

MsgBox at the bottom of the macro will get the file name ...

Please Login or Register  to view this content.

Can you help me fix the code to update multiple *.text files simultaneously?
Thank you.

[tax112]

I already know how.
Thank you everybody.