Problem with Kill Syntax!

[JHB]

I am using excel 2000, and have run into a problem with the kill
process.

I have a path and file name that is constructed by concatenating a
number of fields. The intent is to use this constructed path and file
name to open a spreadsheet, copy selected parts of it, close it and
then kill it.

The opening process works just fine, and I can transfer the data and
close it BUT when I come to killing it it just does not seem to work.
I know its accurate because the other functions are successful.


I have the file and path name called TRUEFILE, and have tried all the
following:

Kill TRUFILE
KillFile TRUEFILE
KillFile=TRUFILE
KillFile=(TRUEFILE)

and none of them have the desired effect. Help please with this simple
one!

Thanks

John Baker

 

[Claus Busch]

Hi John,

Am Fri, 31 Aug 2012 13:23:11 -0700 (PDT) schrieb JHB:

I have the file and path name called TRUEFILE, and have tried all the
following:

Kill TRUFILE
KillFile TRUEFILE
KillFile=TRUFILE
KillFile=(TRUEFILE)

try:
Kill (TRUEFILE)


Regards
Claus Busch