Excel Open workbook- crashing when trying to open

[vbalearner11]

Hello All,

I have a code which is working fine for couple of files but crashing when trying to open a particular file.

Workbooks.Open (UserFolder & Left(FileObj.Name, InStrRev(FileObj.Name, ".") - 1) & ".xlsm")
Workbooks.Open (UserFolder & Left(FileObj.Name, InStrRev(FileObj.Name, ".") - 1) & ".xlsb")

UserFolder & Left(FileObj.Name, InStrRev(FileObj.Name, ".") - 1) this has the folder path without extensions such as ".xlsm" or ".xlsb". Sometimes the extension might be either of them so I cannot just give one line of code.

Looking for help.

Thanks in Advance!

 

[vbalearner11]

I was trying to open a excel workbook with VBA macro code Workbooks.Open("Filepath\Filename.xlsm"). It is crashing as soon as it is opened. When I am trying to open manually then it is not crashing. Any idea or suggestions please.

Looking for help!