| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
code to delete a file
one of my macro generates an output file by the name of SimRes.xls in the
following path D:\~Pradip\~My Documents\2_Personal\RSI\FINAL\simulation results\SimRes.xls every time i run the code, excel prompts that file by that name already exists, do i want to delete it. is it possible to delete the workbook through some code. thanks pradip |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
code to delete a file
Kill "<filename"
"Pradip Jain" wrote: one of my macro generates an output file by the name of SimRes.xls in the following path D:\~Pradip\~My Documents\2_Personal\RSI\FINAL\simulation results\SimRes.xls every time i run the code, excel prompts that file by that name already exists, do i want to delete it. is it possible to delete the workbook through some code. thanks pradip |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
code to delete a file
how do i specify the path of the file.
the code i am writing is in file names RSIfinal.xls which is in the following location: D:\~Pradip\~My Documents\2_Personal\RSI\FINAL\RSIfinal.xls the file i want to delete is the following: D:\~Pradip\~My Documents\2_Personal\RSI\FINAL\simulation results\SimRes.xls what code would i write in the file RSIfinal.xls thanks pradip "Charlie" wrote: Kill "<filename" "Pradip Jain" wrote: one of my macro generates an output file by the name of SimRes.xls in the following path D:\~Pradip\~My Documents\2_Personal\RSI\FINAL\simulation results\SimRes.xls every time i run the code, excel prompts that file by that name already exists, do i want to delete it. is it possible to delete the workbook through some code. thanks pradip |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
code to delete a file
Look up the word Kill in help
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| code to delete module / macro in another file | Excel Discussion (Misc queries) | |||
| Code to delete an Excel File | Excel Discussion (Misc queries) | |||
| Import VBA Code in Excel-File ? (Export VBA Code to file) | Excel Programming | |||
| i need help making code that will open an Xml file for Excel in VB.NET and delete tables that i don't want to show up | Excel Programming | |||
| VBA code delete code but ask for password and unlock VBA protection | Excel Programming | |||
Linear Mode
