Run-time error -2147319784

  • Thread starter Thread starter GermanExcel to Swedish
  • Start date Start date
G

GermanExcel to Swedish

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!
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Application.top=0 fails 3
Run-time error -2147319784 (80028018) when executing a simple macr 3
Problem transferring Excel macros to another language 1
Excel run-time eror 1
Run-time-error 1004 "ListIndex method of listbox class failed" 1
Runtime error 1004: Select method of worksheet class failed 3
VBA ActiveWindow.WindowState Problem 2
Converting workbook to run on German excel 6

Back
Top