Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple Macro to Delete an Excel file at a specific Folder Location
Hello - Could someone possibly let me know what VBA code to use that will simply delete an Excel File at a particular location (on my desktop)?
Not sure if it matters, but I am using Office/Excel 2010 And if it helps, the exact folder location is below. C:\Users\James\SkyDrive\SkyPLT\MainSellerAccount\I mports\DailyImportTemplate\NONSPECPRICING This is probably not relevant, but as an FYI, I will be running this new code PRIOR to running another VBA Macro (that I run daily) that requires that the file that is being deleted is not there, in order to begin. This is because that other VBA Macro seems to be turning off the Macros in that folder, and thus disallowing the Microsoft Access export to export the updated file to that location. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple Macro to Delete an Excel file at a specific Folder Location
Hello - Could someone possibly let me know what VBA code to use that will
simply delete an Excel File at a particular location (on my desktop)? Not sure if it matters, but I am using Office/Excel 2010 And if it helps, the exact folder location is below. C:\Users\James\SkyDrive\SkyPLT\MainSellerAccount\I mports\DailyImportTemplate\NONSPECPRICING This is probably not relevant, but as an FYI, I will be running this new code PRIOR to running another VBA Macro (that I run daily) that requires that the file that is being deleted is not there, in order to begin. This is because that other VBA Macro seems to be turning off the Macros in that folder, and thus disallowing the Microsoft Access export to export the updated file to that location. Have a look at the VBA Kill() function! -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to Save File to specific location when closing | Excel Discussion (Misc queries) | |||
How to find all folder and/or files in a specific location | Excel Programming | |||
How to find all folder and/or files in a specific location | Excel Discussion (Misc queries) | |||
can excel automaticaly open file from specific folder | Excel Discussion (Misc queries) | |||
FYI: One macro really helped for capturing data from multiple workbook stored in a specific folder to one excel file only | Excel Programming |