method open of object workbooks failed

[dpaton05]

While working on a spreadsheet at work, I was getting the error "method open of object workbooks failed", but when I got home, the same file was not giving me any errors. Any ideas why?

 

[dpaton05]

I don't understand Michael. They are both correct.

 

[dpaton05]

I closed the file without saving it and opened it again as I have not done anything on it today. It is not saying subscript out of range anymore, it is now saying the error is method open of object workbooks failed. It highlights the same line of code.

Workbooks.Open (ThisWorkbook.Path & "" & DocYearName)

 

[Michael M]

Ok try either

Workbooks.Open (ThisWorkbook.Path & " " & DocYearName)

OR

Workbooks.Open (ThisWorkbook.Path & "\" & DocYearName)

When you use your error code

Workbooks.Open (ThisWorkbook.Path & "" & DocYearName)

what do you get ??
I mean what text appears for each variable ?

 

[Norie]

Dave

Kind of curious, what's the purpose of the If here?

If Workbooks(ThisWorkbook.Path & "" & DocYearName).Open = True Then

PS If you move the workbook(s) to local storage, e.g. into a folder on the C:\ drive of the computer/laptop, do you have any problems opening workbooks?

 

[dpaton05]

I'm sorry, the line of code that I am using should or read

Workbooks.Open Filename:=ThisWorkbook.Path & "\" & DocYearName

I made a typo in post 12

 

[dpaton05]

If I use

Workbooks.Open (ThisWorkbook.Path & "" & DocYearName)

I get an error saying the file can't be found.

If I use

Workbooks.Open (ThisWorkbook.Path & "" & DocYearName)

I get the same error.

 

[dpaton05]

Dave

Kind of curious, what's the purpose of the If here?

I read on a forum that a possible fix is to make sure the workbook is closed before you copy to it. It didn't work for me so I just commented it out.

 

[Michael M]

Both lines of code look the same to me !!
Did you take Nories advice of moving the file to say the C:\ Drive??

 

[dpaton05]

PS If you move the workbook(s) to local storage, e.g. into a folder on the C:\ drive of the computer/laptop, do you have any problems opening workbooks?

I get the same error. Do you think that the workbook may have been corrupted as I read somewhere that could be a possible cause for the error?

 

[Norie]

Can you open the workbook manually either by double clicking the file or opening it from within Excel?