Workbooks Open Issue

[reberryjr]

I've been using this line of code for weeks with no problems. Now all of a sudden, it wants to fail. I've verified that the file path is correct, and that the file exists. I've tried adding DoEvents before and after this line, but it continues to fail. All I get is the Method Open of Objects Workbooks Failed error.

Thoughts?

Set cs = Workbooks.Open("C:\Users\Rodger\Desktop\Bodies by Trish\CS Template.xlsm")

 

[steve the fish]

What does it do?

 

[reberryjr]

Sorry about that. I added that to the OP. I'm getting the Method Open of Objects Workbooks Failed error.

 

[steve the fish]

Can you open it manually without error?

 

[reberryjr]

I just tried and get an error saying it found "unreadable content". Not sure what it's considering unreadable.

 

[steve the fish]

Thats why it fails. You need to repair that and it will be ok.

 

[reberryjr]

I'm unclear on how it "broke" to begin with.

 

[steve the fish]

It isnt uncommon but as to how it got there you will need to investigate. It can be many reasons.

 

[reberryjr]

So far, it seems to have been some formulas that were trying to calculate data that wasn't present yet. I adjusted them, and was able to use the spreadsheet as intended. Hopefully it doesn't happen again.