Weird Excel Behavior - Have you seen this?

[srmcmains]

I have a user that is not able to get an excel file to open. This is what it does. It will open, but nothing will come up on his screen. Almost like it is locked up, but if he does print preview, he can see it. Anyone else that opens this file is able to open it no problem. Have you ever seen this and any ideas why this is happening? He is on excel 97 Windows 2000.

Thanks, Shawnna

 

[MartinK]

Isn't it an add-in? I mean with *.xla extension?
Martin

 

[srmcmains]

I guess I'm not sure what you mean by an add-in???? It seems like all the other excel files.

 

[PaddyD]

what's the file name & extension?

 

[srmcmains]

it's Rimage 626411.xls.

 

[MartinK]

OK, just to be sure:
Open the file, Go to VB Editor (Alt+F11), and put this in the Immediate window:

? ThisWorkbook.IsAddin

Hit Enter. What does it say? False or True?
Martin

 

[MartinK]

Another idea:
try to run this code

Sub Unhide()
For Each ws In Workbooks("Rimage 626411.xls").Sheets
    ws.Visible = True
Next ws
End Sub

Maybe it's an old file with hidden module sheets.
Martin

 

[srmcmains]

No matter where I put it, I keep getting this error. "438 - Object doesn't support this method."

I put it in the immediate window. Created a macro and then put it in that area, and even created a form and then added a button to it and had the code on the button. Still will not take the code.

 

[srmcmains]

No matter where I put it, I keep getting this error. "438 - Object doesn't support this method."

I put it in the immediate window. Created a macro and then put it in that area, and even created a form and then added a button to it and had the code on the button. Still will not take the code.

 

[MartinK]

It's strange that you can see the workbook in preview.
Where do you get the 438 error? In both cases? The .IsAddin is also not working?
Do you have a name of some sheet inside the book? We can try to retrieve the values either via formulas or via XLM code.
Martin