Weird Excel Behavior - Have you seen this?

srmcmains

New Member
Joined
Jul 14, 2003
Messages
9
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
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

srmcmains

New Member
Joined
Jul 14, 2003
Messages
9
I guess I'm not sure what you mean by an add-in???? It seems like all the other excel files.
 

srmcmains

New Member
Joined
Jul 14, 2003
Messages
9

ADVERTISEMENT

it's Rimage 626411.xls.
 

MartinK

Active Member
Joined
Oct 30, 2003
Messages
384
OK, just to be sure:
Open the file, Go to VB Editor (Alt+F11), and put this in the Immediate window:
Code:
? ThisWorkbook.IsAddin
Hit Enter. What does it say? False or True?
Martin
 

MartinK

Active Member
Joined
Oct 30, 2003
Messages
384

ADVERTISEMENT

Another idea:
try to run this code
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

New Member
Joined
Jul 14, 2003
Messages
9
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

New Member
Joined
Jul 14, 2003
Messages
9
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

Active Member
Joined
Oct 30, 2003
Messages
384
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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,151,871
Messages
5,766,855
Members
425,380
Latest member
CubeGirl

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top