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

"Guenter" skrev i melding
...

The file is not generated.


Error then. Thought so. Can you have the code written in and ran in a
workbook freshly generated on the system where the code runs ? Any skilled
users there ? This for a test to avoid possible bogus references and
translation flaws.

Didn't think of trying it from Word - that's a good idea. Unfortunately

the
customer is 700km away, but maybe I can just do a little routine in a Word
Macro to test the situation - thx for the tip


I'd say either Excel or VBA or Windows is corrupt on the system. A thing
like that 3-liner should simply work no matter what. If Word can do it then
it's Excel. (I'd love a few days in France to test this and enjoy some
Kronenbourgs in the evenings, but neither of us can afford that I guess <g)

I created files in the Directory concerned with Note-Pad and deleted the
files with the Explorer so there doesn't seem to be a problem of access
protection


Good. My experience is that code like that runs fine with "modify"
priviledges only. But you never know with the french <g.

This program works on about 150 different systems in france . . . this

site
is the ONLY ONE that presents this problem, so it's not a problem related

to
the language version.


Something must imo be seriously broken. So you just have to narrow it down
so we which part it is. The FSO approach may or may not solve this single
problem, but things like this indicate trouble deep down and you never know
when or where it strikes the next time. Or maybe I'm just paranoid... Please
post back progress or solutions, this is very interesting.

Best wishes Harald


 
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 11:18 AM.

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"