| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete spreadsheet
Good Morning,
I'm not sure how to address my issue, without explaining in detail what I'm trying to do (going to be a bit 'wordy'). I have a macro that pulls data from our web-site, filters and formats the data and saves five separate files, for further manipulation. After the final spreadsheet is populated with the data needed for distribution, I'd like to somehow go back and delete four of those 'saved' spreadsheets. How can I delete programmatically? More than likely this is another simple task, which I'm just failing to realize. Thanks in advance for any assistance provided. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
delete spreadsheet
Kill "C:\Myfolder\Myfile.xls"
will delete the referenced file (it should not be open). It doesn't not put a copy in the recycle bin. -- Regards, Tom Ogilvy "Johnny Mick" wrote: Good Morning, I'm not sure how to address my issue, without explaining in detail what I'm trying to do (going to be a bit 'wordy'). I have a macro that pulls data from our web-site, filters and formats the data and saves five separate files, for further manipulation. After the final spreadsheet is populated with the data needed for distribution, I'd like to somehow go back and delete four of those 'saved' spreadsheets. How can I delete programmatically? More than likely this is another simple task, which I'm just failing to realize. Thanks in advance for any assistance provided. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
delete spreadsheet
figured it was something simple. If I may take a moment; I'd like to thak
you, and all of the other folks that utilize these discussion groups. Thanks to you guys, my boss thinks I'm an Excel genius. Ya'll do good work. Happy St. Patrick's Day. "Tom Ogilvy" wrote: Kill "C:\Myfolder\Myfile.xls" will delete the referenced file (it should not be open). It doesn't not put a copy in the recycle bin. -- Regards, Tom Ogilvy "Johnny Mick" wrote: Good Morning, I'm not sure how to address my issue, without explaining in detail what I'm trying to do (going to be a bit 'wordy'). I have a macro that pulls data from our web-site, filters and formats the data and saves five separate files, for further manipulation. After the final spreadsheet is populated with the data needed for distribution, I'd like to somehow go back and delete four of those 'saved' spreadsheets. How can I delete programmatically? More than likely this is another simple task, which I'm just failing to realize. Thanks in advance for any assistance provided. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
delete spreadsheet
Can this be done with a variable instead of the explicit path in quotes? I
assume so - like this: Kill PathToMyFile -- Thanks, Andy "Johnny Mick" wrote: figured it was something simple. If I may take a moment; I'd like to thak you, and all of the other folks that utilize these discussion groups. Thanks to you guys, my boss thinks I'm an Excel genius. Ya'll do good work. Happy St. Patrick's Day. "Tom Ogilvy" wrote: Kill "C:\Myfolder\Myfile.xls" will delete the referenced file (it should not be open). It doesn't not put a copy in the recycle bin. -- Regards, Tom Ogilvy "Johnny Mick" wrote: Good Morning, I'm not sure how to address my issue, without explaining in detail what I'm trying to do (going to be a bit 'wordy'). I have a macro that pulls data from our web-site, filters and formats the data and saves five separate files, for further manipulation. After the final spreadsheet is populated with the data needed for distribution, I'd like to somehow go back and delete four of those 'saved' spreadsheets. How can I delete programmatically? More than likely this is another simple task, which I'm just failing to realize. Thanks in advance for any assistance provided. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
delete spreadsheet
Yep.
AndyC812 wrote: Can this be done with a variable instead of the explicit path in quotes? I assume so - like this: Kill PathToMyFile -- Thanks, Andy "Johnny Mick" wrote: figured it was something simple. If I may take a moment; I'd like to thak you, and all of the other folks that utilize these discussion groups. Thanks to you guys, my boss thinks I'm an Excel genius. Ya'll do good work. Happy St. Patrick's Day. "Tom Ogilvy" wrote: Kill "C:\Myfolder\Myfile.xls" will delete the referenced file (it should not be open). It doesn't not put a copy in the recycle bin. -- Regards, Tom Ogilvy "Johnny Mick" wrote: Good Morning, I'm not sure how to address my issue, without explaining in detail what I'm trying to do (going to be a bit 'wordy'). I have a macro that pulls data from our web-site, filters and formats the data and saves five separate files, for further manipulation. After the final spreadsheet is populated with the data needed for distribution, I'd like to somehow go back and delete four of those 'saved' spreadsheets. How can I delete programmatically? More than likely this is another simple task, which I'm just failing to realize. Thanks in advance for any assistance provided. -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
delete spreadsheet
OK. It's giving me an error saying action not allowed or something like
that. I think it is because the file is linked to an open Word file. I haven't been able to figure out how to close that Word file yet. I have a separate question on the board for that one. I suspect if that file is closed I can delete the data file, no problem. -- Thanks, Andy "Dave Peterson" wrote: Yep. AndyC812 wrote: Can this be done with a variable instead of the explicit path in quotes? I assume so - like this: Kill PathToMyFile -- Thanks, Andy "Johnny Mick" wrote: figured it was something simple. If I may take a moment; I'd like to thak you, and all of the other folks that utilize these discussion groups. Thanks to you guys, my boss thinks I'm an Excel genius. Ya'll do good work. Happy St. Patrick's Day. "Tom Ogilvy" wrote: Kill "C:\Myfolder\Myfile.xls" will delete the referenced file (it should not be open). It doesn't not put a copy in the recycle bin. -- Regards, Tom Ogilvy "Johnny Mick" wrote: Good Morning, I'm not sure how to address my issue, without explaining in detail what I'm trying to do (going to be a bit 'wordy'). I have a macro that pulls data from our web-site, filters and formats the data and saves five separate files, for further manipulation. After the final spreadsheet is populated with the data needed for distribution, I'd like to somehow go back and delete four of those 'saved' spreadsheets. How can I delete programmatically? More than likely this is another simple task, which I'm just failing to realize. Thanks in advance for any assistance provided. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I delete specified times from a spreadsheet | Excel Worksheet Functions | |||
| how do i delete the data in one spreadsheet from another | Excel Discussion (Misc queries) | |||
| delete all the spreadsheet | Excel Discussion (Misc queries) | |||
| delete all the spreadsheet | Excel Programming | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
![Johnny Mick[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
