VBA only opening XLSM and not other extension

[CWever]

All,

I'm running below code

Please Login or Register  to view this content.

If the "OtherWorkbook" has an xlsm extension it will open, if it has any other excel extensions it will not open. I'm getting an error saying the file extension is not correct.
Any help? I find it weird. I don't see anywhere in the code referring to only open xlsm files.

Any help would be much appreciated.

-=CWever=-

[Keebellah]

Hi, the code looks okay for as far as I can see. Without tyhe actual file you're using to do this I cannot tell what's in the userform you're using.
The only thing that I can come up with is that either the selected file(s) have an incorrect extension or that you're changing the extension when the code in the userform is executed
May you've accidentally include a FiletType parameter?

[AlphaFrog]

As a test, can you manually open the other files without error?

[CWever]

Hi, the code looks okay for as far as I can see. Without tyhe actual file you're using to do this I cannot tell what's in the userform you're using.
The only thing that I can come up with is that either the selected file(s) have an incorrect extension or that you're changing the extension when the code in the userform is executed
May you've accidentally include a FiletType parameter?

As far as I can read and understood, no I did not use the FileType parameter.

Here is the User.Form code.

Please Login or Register  to view this content.

And no, I don't change the file extension anywhere and neither manually.
And all files open if I open them normally.

[Keebellah]

Have you check what @AlfaFrog suggested?
BTW the macro code is of no help, I suggest you attach the file WITH the macro's