Run-time error -2147319784
 

We have an Excel 2000 file, converted to Excel 97 which
has been produced in Germany. We will run the file in
Sweden, but on our Windows 2000 computer with Excel 97 it
doesn't work. We got the Run-time error on
Method "WindowState" of object "Window" failed.

Private Sub Workbook_Open()
ActiveWindow.WindowState = xlMaximized

Do we have some strainge configurations or what??

The file works on Windows XP with Excel 2003

Please help!

Run-time error -2147319784
 

I've seen a few posts that suggest that workbook_open and auto_open can have
timing trouble when you're opening the workbook.

This might not even be close to the problem/solution, but maybe you can try
this:

Private Sub Workbook_Open()
Application.OnTime Now, "Continue_Open"
End Sub

Then in a General module,

sub Continue_Open()
ActiveWindow.WindowState = xlMaximized
end sub

GermanExcel to Swedish wrote:

We have an Excel 2000 file, converted to Excel 97 which
has been produced in Germany. We will run the file in
Sweden, but on our Windows 2000 computer with Excel 97 it
doesn't work. We got the Run-time error on
Method "WindowState" of object "Window" failed.

Private Sub Workbook_Open()
ActiveWindow.WindowState = xlMaximized

Do we have some strainge configurations or what??

The file works on Windows XP with Excel 2003

Please help!

--

Dave Peterson