Excel workbook crashing when trying to open with vba Code

[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!

 

[NdNoviceHlp]

U need to specify the entire path of the workbook that U want to open not the filepath or filename of the existing workbook. HTH. Dave

 

[vbalearner11]

I did mention. It was working for other files but only for this file it's crashing.

 

[vbalearner11]

I am not able to make any changes to .xlsm file If i try to do so it is crashing. Can anyone tell me if I have to change any settings please.

 

[NdNoviceHlp]

Again, that is not a valid filepath. If U want the file path to use, open the workbook and run this code...

Sub test()
MsgBox ThisWorkbook.FullName
End Sub

Now to open that workbook from another workbook...

Workbooks.Open filename:= "Enter whatever it said in the test sub here in quotes"

When asking for help, one should accept, or at least trial the assistance provided. Dave