NULL pointer problem Error=[0x80040204]

[sebt]

Hi

Someone else posted on this last year, but no replies.

This error message comes up if I try to open an Excel file from
Explorer, rather than from Excel itself (File/Open). I'm using Excel
2000 (9.0.6926 SP3).

If I get rid of the error message by clicking OK, it reappears a couple
of times, then I get Excel shown, showing the name of the file in the
window caption bar - also, the contents of A1 are shown in the
whatdjewcallit editing toolbar. But the spreadsheet is completely
blank, and Excel doesn't respond to any mouse or keyboard input.

Opening it through Excel (File/Open) is fine. Also, double-clicking
from Explorer works fine, AS LONG AS there's an instance of Excel
already running (it opens in that instance).

Saving the file again, or making a nonsense change to a cell and then
saving it, makes no difference.

This is a file created from Access VBA through the Excel 9.0 COM
objects. Other files created in this way don't have this problem.
There's no workaround, Access has to create this file in this way; and
there's nothing at all in the MS KB.

Anyone have any ideas?

 

[Jim Rech]

I've never seen this phenomenon but since the workbook opens fine from File,
Open it would seem to be a problem with Excel versus the workbook itself.
The only thing I can suggest is that you have Excel re-register itself in
case there is something not right with its file associations. From
Start->Run enter "Excel.exe /regserver" (no quotes, there is a space before
the slash).

If that doesn't help there is the old fallback, reinstalling Excel. That
seldom fixes anything though.

--
Jim
| Hi
|
| Someone else posted on this last year, but no replies.
|
| This error message comes up if I try to open an Excel file from
| Explorer, rather than from Excel itself (File/Open). I'm using Excel
| 2000 (9.0.6926 SP3).
|
| If I get rid of the error message by clicking OK, it reappears a couple
| of times, then I get Excel shown, showing the name of the file in the
| window caption bar - also, the contents of A1 are shown in the
| whatdjewcallit editing toolbar. But the spreadsheet is completely
| blank, and Excel doesn't respond to any mouse or keyboard input.
|
| Opening it through Excel (File/Open) is fine. Also, double-clicking
| from Explorer works fine, AS LONG AS there's an instance of Excel
| already running (it opens in that instance).
|
| Saving the file again, or making a nonsense change to a cell and then
| saving it, makes no difference.
|
| This is a file created from Access VBA through the Excel 9.0 COM
| objects. Other files created in this way don't have this problem.
| There's no workaround, Access has to create this file in this way; and
| there's nothing at all in the MS KB.
|
| Anyone have any ideas?
|

 

[jimhong]

Hi,

I just wanted to pass this info on to others that I've encounter this error when trying to use Application.Quit in VBA. To correct this, you have to close the application first so use..

Sub someSub()

some codes...

ActivePresentation.Close
Application.Quit

end Sub


Hope this helps

JH