| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete an xls file using a .xl macro in a different file?
I have an application where I am importing data from an .xls
file,manipulating it and saving it in a different file. From the second file I need to create a macro that will delete the original file! I need to do this because there is a seperate application creating the feeder file, and if I create more than opne file it gets stored with the count after it as in: Feeder.xls Feeder(1).xls Feeder(2).xls etc I know exactly where the file will be (in what folder and drive), I just dont have a clue as to how to write a macro to remove it. I am using Excel 2000. Thanks in advance John Baker |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I delete an xls file using a .xl macro in a different file?
After you import the data, you can use Kill to delete the file.
Kill "x:\yourpathtothefile\feeder.xls" JHB wrote: I have an application where I am importing data from an .xls file,manipulating it and saving it in a different file. From the second file I need to create a macro that will delete the original file! I need to do this because there is a seperate application creating the feeder file, and if I create more than opne file it gets stored with the count after it as in: Feeder.xls Feeder(1).xls Feeder(2).xls etc I know exactly where the file will be (in what folder and drive), I just dont have a clue as to how to write a macro to remove it. I am using Excel 2000. Thanks in advance John Baker -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I delete an xls file using a .xl macro in a different file?
Hi John
Look at the "Kill" statement in help. Regards, Per "JHB" skrev i meddelelsen ... I have an application where I am importing data from an .xls file,manipulating it and saving it in a different file. From the second file I need to create a macro that will delete the original file! I need to do this because there is a seperate application creating the feeder file, and if I create more than opne file it gets stored with the count after it as in: Feeder.xls Feeder(1).xls Feeder(2).xls etc I know exactly where the file will be (in what folder and drive), I just dont have a clue as to how to write a macro to remove it. I am using Excel 2000. Thanks in advance John Baker |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I delete an xls file using a .xl macro in a differentfile?
On Aug 2, 3:56*pm, Dave Peterson wrote:
After you import the data, you can use Kill to delete the file. Kill "x:\yourpathtothefile\feeder.xls" JHB wrote: I have an application where I am importing data from an .xls file,manipulating it and saving it in a different file. From the second file I need to create a macro that will delete the original file! I need to do this because there is a seperate application creating the feeder file, and if I create more than opne file it gets stored with the count after it as in: Feeder.xls Feeder(1).xls Feeder(2).xls etc I know exactly where the file will be (in what folder and drive), I just dont have a clue as to how to write a macro to remove it. I am using Excel 2000. Thanks in advance John Baker -- Dave Peterson Thank you very much! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i delete a file from recent documents file in excel | New Users to Excel | |||
| code to delete module / macro in another file | Excel Discussion (Misc queries) | |||
| delete info from source file w/out changing the destination file | New Users to Excel | |||
| Open & delete file using a macro | Excel Discussion (Misc queries) | |||
| Can't find macro in an Excel file to delete it | Excel Discussion (Misc queries) | |||
Linear Mode
