LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Inexplicable crash in VBA

We ship a small Excel VBA application with our Time Reporting Terminal. About
150 have been installed without a hitch - as far as I know under all past and
present versions of Excel. In ONE particular case (which unfortunately
happens to be the french government) the instruction :

OPEN Text_File_Name FOR OUTPUT AS #n

causes the code to terminate WITHOUT ANY SORT OF ERROR MESSAGE (behaves just
like an END statement). This happens in normal RUN mode as well as in
Step-by-Step Debug mode. Obviously since none of the code following the
statement is ever executed the application does not work.

The same error occurs with "APPEND". However, "OPEN FOR INPUT" works
correctly.

The environment is Excel 2000 under XP. The directory referenced exists and
is accessible (I can create a text file in the directory with WordPad). The
error occurs whether the file already exists or not. The Anti-Virus program
on the PC concerned (Kaspersky) was turned off - no difference. The same
error occurs on another PC at the same site with identical configuration.

I'm getting desperate - has anybody out there encountered a similar
situation? I would be very grateful for any sort of help on this!

--
Guenter Kloepper
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
INEXPLICABLE FORMULA RESULT William Excel Discussion (Misc queries) 6 July 29th 08 12:06 PM
Inexplicable VBA errors in formulas Dallman Ross Excel Discussion (Misc queries) 7 August 11th 07 12:32 AM
Nested IF AND OR function Inexplicable error MichaelC Excel Worksheet Functions 7 August 22nd 05 10:46 PM
Crash on every 2nd run Christof[_4_] Excel Programming 1 September 29th 03 08:50 PM
Crash on every 2nd run Christof[_4_] Excel Programming 0 September 29th 03 07:57 AM


All times are GMT +1. The time now is 01:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"