Since some days, I have some problems with VBA (with Access as well as
Word).
All these problems exist in Office 2000 as well as in 2003
Some VBA functions do not vork anymore.
==========================================================
So the function 'Kill' is completly unefficient. I mean that 'Kill' doesn't
kill files, but, worse, give no error message if I ask to 'Kill' a file
which does not exists (for example with a bad path).
So the line :
-----------
Kill "c:\program files\internet explorer\iexplore.exe"
-----------
does not give a message. Just the program quit the function where is the
line without executing the lines after.
There is no error treatment un function.
If I put a Rem or a "'" at the begining of the line, the lines after are
executed.
If the path of the program to kill is bad (for example "c:\progr
files\internet explorer\iexplore.exe" , there is no error message!
==========================================================
The function 'Mkdir' does not work anymore.
So the line :
-----------
MkDir "c:\xxxxx"
-----------
doen't create the dirextory 'xxxxx'.
==========================================================
The procedure :
-----------
Sub Test ()
Dim FileNumber as integer
FileNumber = FreeFile
Open "c:\TEST" For Output As #FileNumber
Write #FileNumber, "Ceci est un exemple"
Close #FileNumber
End Sub
-----------
does'nt create the file and the error message says that the file does not
exist !
It do not accept to create it...
==========================================================
The function 'Shell' does not work anymore.
So the line
-----------
Shell "c:\program files\internet explorer\iexplore.exe", vbMaximizedFocus
-----------
does'nt launch Internet Explorer.
If the path given in string is bad, there is no error message.
==========================================================
I don't know if the following problem is bound to there others problems, but
now I cannot use the function "Export in Word" or "Export in Excel" or
"Export in 'presse-papier'" for exportations of preview of report.
No problem if I export to Word a preview of a form or of a table or of a
query.
But it is now impossible to export a report preview towards Word.
===========================================================
I have Windows XP PRO.
I have Office 2000 developer, and Office 2003.
All these problems can be observed VBA 2000 AND VBA 2003 (in Accesss 2003).
============================================================
I have uninstalled and reinstalled twice both Office 2003 and Office 2000.
No results.
============================================================
On my second computer, all is good.
To replace filesystem functions I use 'Scripting.FileSystemObject', which
works PERFECTLY.
============================================================
The functions that does not work on my pricipal computer work on the second
computer.
Which can be ABOVE VBA in the first computer which can cause this kind of
problems ?
HOW CAN I REPLACE the 'Shell' function ?
Thanks for responses. And excuses for my english. I am french...