getting files' extensions?

Hi all. After some excellent advice from shg, I've figured out that a user defined data type is exactly what I need to make my file cataloging project move forward. Now, I have a simpler question. How do I get the extension of a given file? I know that I can do a long, drawn out process of searching each file's name for the "." character, verifying that it's near the end of the string, counting its position, and clipping the characters before it. But, I assume there's some much simpler way to do it. Here's my code:

Please Login or Register  to view this content.

As you can see, I tried the GetExtensionName method, but it just didn't work. I get runtime error 438, "Object does not support this property or method." According to Help, I need a FileSystemObject before the method, and I need to have a path as the argument. I believe I've done both those things, but it appears I have not. Any suggestions?

maybe

Please Login or Register  to view this content.

Originally Posted by royUK

maybe

Please Login or Register  to view this content.

Roy,

That's what I would do in a simple case. However, some files have extensions that are 2 letters long and some have 4. I could make some logic to capture all those cases, but it seems like the GetExtensionName method should do what I need if only I knew how to use it correctly.

Maybe

Please Login or Register  to view this content.

Originally Posted by royUK

Maybe

Please Login or Register  to view this content.

That was it! Thanks a bunch.