Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
Run time error 1004, General ODBC error | New Users to Excel | |||
Code Error - Run Time Error 5 (Disable Cut, Copy & Paste) | Excel Programming | |||
Run-time error '11' & Run-time error '1004' | Excel Programming | |||
Run-time error '11' & Run-time error '1004' | Excel Programming |