Vba filesystemobject get file extension

I can not figure out whats wrong with this code. Could you please help me? Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 5 years, 6 months ago. Active 5 years, 6 months ago. Viewed 17k times. Sheets SheetName. Cells Rows. Count, 2. End xlUp. Improve this question. Rickest Rick 1, 1 1 gold badge 14 14 silver badges 26 26 bronze badges.

Shan Shan 3 3 gold badges 11 11 silver badges 28 28 bronze badges. Nothing wrong. It retrieves all xl files correctly. Add a comment. Active Oldest Votes. Path, True It will work. Improve this answer. Is this page helpful?

Please rate your experience Yes No. Any additional feedback? In this article. Creates a text file and returns a TextStream object that can be used to read from, or write to the file. Returns the complete path from the root of the drive for the specified path. Returns a Drive object corresponding to the drive in a specified path. Returns the file extension name for the last component in a specified path. Returns the file name or folder name for the last component in a specified path.

Returns the name of the parent folder of the last component in a specified path. Opens a specified file and returns a TextStream object that can be used to read from, write to, or append to the file.

Opens a file and returns a TextStream object that can be used to access the file. Writes a specified string and new-line character to a TextStream file.