Excel found unreadable content message

[ipbr21054]

Evening,

Never seen this message before but now see it say 4 times in two weeks.
Clicking YES on the message then shows second screen shot
See screen shot supplied.


I have a worksheet which has command buttons.
Each command button opens a worksheet.

Here is a code that is common.

I use these worksheets most days & no changes have been made & they worked BUT now this ??

Private Sub ObdToolInfo_Click()
Workbooks.Open Filename:="C:\Users\Ian\Desktop\REMOTES ETC\DR\EXCEL WORKSHEETS\OBD TOOL INFO.xlsm"
End Sub

 

[pbornemeier]

If you manually open the file do you get the same message?
Could the method/process you use to get OBD TOOL INFO.xlsm generate a corrupted file periodically?
Try using

Workbooks.Open Filename:="C:\Users\Ian\Desktop\REMOTES ETC\DR\EXCEL WORKSHEETS\OBD TOOL INFO.xlsm", CorruptLoad:=True

I would guess that you have a bad sector on your drive or the file was imported from another machine and got corrupted in the transfer.

 

[ipbr21054]

Thanks for the reply.
Since I posted it I’ve opened each worksheet many times and no longer see this message so I assume now all is well.

I had moved the files from one workbook to there own worksheet.
Somewhere along that path they must have run into a problem but I think it’s all sorted now.
Have a nice day.

 

[RoryA]

It looks like you created an invalid named range at some point.

 

[ipbr21054]

Yes maybe.