| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Code to delete an Excel File
I must be missing something but I am having trouble trying to write a macro
to delete and Excel file. I have tried the following but does not work...... Application.Workbooks("N:\MaintCo-ord\Mech\Maint Day Roster for Viewing.xls").Delete Can anyone point me in the right direction. Thanks Ray |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Code to delete an Excel File
Ray,
The VB VBA command is KILL. Kill "N:\MaintCo-ord\Mech\Maint Day Roster for Viewing.xls" John "Ray Clark" wrote in message ... I must be missing something but I am having trouble trying to write a macro to delete and Excel file. I have tried the following but does not work...... Application.Workbooks("N:\MaintCo-ord\Mech\Maint Day Roster for Viewing.xls").Delete Can anyone point me in the right direction. Thanks Ray |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Code to delete an Excel File
John,
Thank you this was a great help as had not picked this up before. Much appreciated. Ray "jaf" wrote: Ray, The VB VBA command is KILL. Kill "N:\MaintCo-ord\Mech\Maint Day Roster for Viewing.xls" John "Ray Clark" wrote in message ... I must be missing something but I am having trouble trying to write a macro to delete and Excel file. I have tried the following but does not work...... Application.Workbooks("N:\MaintCo-ord\Mech\Maint Day Roster for Viewing.xls").Delete Can anyone point me in the right direction. Thanks Ray |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Open a file with the help of a code in Excel | New Users to Excel | |||
| cannot delete excel file | Excel Discussion (Misc queries) | |||
| How to hide VB code from Excel file | Setting up and Configuration of Excel | |||
| Code to Open Excel File Please Help | Excel Discussion (Misc queries) | |||
| excel file deleted. Now howdo you delete file NAME | New Users to Excel | |||
![Ray Clark[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
