I want to delete a workbook using code

[writelearner]

is it possible

thanks anyway

[Ecniv]

Yes.

Kill "<filepath" <<< Deletes the file

To delete a worksheet (outside excel vb/vba)
<object refering to excel application>.<workbook>.sheets("<sheetname").delete

Inside excel vba
activesheet.delete
or
activeworkbook.sheets("<sheet name>").delete



Try one of those :)


Vince

[writelearner]

lets kill them all

thanks a lot

er maybe you know how to create a folder too :wave:

[Ecniv]

mkdir - make directory/folder
rmdir - remove folder
open - open a file or create one
close - close the channel of an open file
kill - delete file (not put in wastebasket!! - look up api to put in wastebasket)
print - prints a string to a file
line input - inputs a line from an open file
get - get byte(s) from a file
put - put byte(s) into a file

You'll have to search the help files for proper usage.

Make sure you back up everything.


Vince

[writelearner]

thanks a lot. it will be usefull

[writelearner]

thanks a again