Use Windows API to determine if string is a file or a folder

[mc84excel]

I am looking for a function that will use a Windows API to check whether the passed string is a file or a folder.

I used to use GetAttrib() but I can no longer rely on this as it runs into an error on long file names (i.e. when folder path exceeds 247 characters or file fullpath exceeds 260 characters)(218 len if the file is an excel workbook)

I have worked out a function that does this in FileSystemObject but I would prefer to use a Windows API to avoid the performance hit of FSO.

[Kyle123]

I'd have thought that this should cover it, you can use the Unicode version if you need even longer paths. See: https://docs.microsoft.com/en-us/win...ectedfrom=MSDN.

This should also answer your other question

Please Login or Register  to view this content.

[mc84excel]

Many thanks for this Kyle.

I have tried to rewrite the function to support extended paths. I rarely use Windows APIs so I'm not sure what I'm doing! Is the code below OK for GetFileAttributesW ?

Also does anybody know if there is a separate 64 bit version of GetFileAttributesW or do I just use PtrSafe prefix?

Please Login or Register  to view this content.

[mc84excel]

My modified function 'fnfptPathType' returns -1 for all arguments passed. However if I call this from another function 'fnblnPathStringIsFolder' it works?!

The 'fnblnPathStringIsFolder' function has passed my testing so I am using that.

Thanks again Kyle. (The forum wont let me rep you because I just repped you for the function that uses windows API to verify file/folder exists)

Please Login or Register  to view this content.

[Kyle123]

Your code doesn't work, since you're calling a unicode function, you need to pass the stringas unicode:

Please Login or Register  to view this content.

Should be:

Please Login or Register  to view this content.

Also, this is a bit nasty:

Please Login or Register  to view this content.

This would be cleaner and easier to test:

Please Login or Register  to view this content.

Then:

Please Login or Register  to view this content.

[mc84excel]

Your code doesn't work, since you're calling a unicode function, you need to pass the stringas unicode:

Please Login or Register  to view this content.

Should be:

Please Login or Register  to view this content.

Thanks Kyle. I have corrected this.

Also, this is a bit nasty:

Yes I agree it's messy. I have use for a module level variable here to be used by other functions in this module (I didn't mention these functions earlier since they are outside the focus of my original question)

Thanks again for your help Kyle. I apologise that I am unable to rep you for solving both threads as the forum wont allow me to rep the same user in succession!