Use the older style file io eg

Dim TextLine
Open "TESTFILE" For Input As #1   ' Open file.
Do While Not EOF(1)   ' Loop until end of file.
   Line Input #1, TextLine   ' Read line into variable.
   Debug.Print TextLine   ' Print to the Immediate window.
Loop
Close #1   ' Close file.

why not use KILL

Syntax

Kill pathname

The required pathnameargument is astring expression that specifies one or
more file names to be deleted. The pathname may include the directory or
folder, and the drive.

Remarks

In Microsoft Windows, Kill supports the use of multiple-character (*) and
single-character (?) wildcards to specify multiple files

HTH
-----Original Message-----
From: helga@k... [mailto:helga@k...]
Sent: 25 June 2002 12:18
To: professional vb
Subject: [pro_vb] Alternative ways on doing things?


Hi All

Due to the endless problems i've got and don't seem to overcome at this 
stage with the sccrun.dll and msadox.dll when it comes to the package and 
deployment wizard, I need to change my code and project references.

Is there any other way, not to complicated, to do one of the following:

a.  Stream a file (line by line) in and not using the scripting library 
(thus no references to the scripting library and therefor not using the 
filesystemobject thing) and then also writing to a file without the 
scripting reference.

b.  Another way creating and destroying a mdb database without reference 
to the adox control in microsoft, thus not using the dim xxx as table, dim 
zzz as adox.key nor using dim yyy as adox.catalog.

Your assistance will really be appreciated.

Regards
Helga


THIS E-MAIL AND ANY ATTACHED FILES ARE CONFIDENTIAL AND MAY BE LEGALLY
PRIVILEGED. If you are not the addressee, any disclosure, reproduction,
copying, distribution or other dissemination or use of this communication is
strictly prohibited. If you have received this transmission in error please
notify the sender immediately and then delete this e-mail. 
Opinions, advice or facts included in this message are given without any
warranties or intention to enter into a contractual relationship with the
Corporation of London unless specifically indicated otherwise by agreement,
letter or facsimile signed by an authorised signatory of the Corporation. 
Any part of this e-mail which is purely personal in nature is not authorised
by the Corporation of London. All e-mail through the Corporation's gateway
is potentially the subject of monitoring. 
All liability for errors and viruses is excluded.