Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Workbook
I've written some code that creates a workbook, emails it
to specific users, then closes it. I'd like to have my code go in a delete the workbook. Any suggestions? Thanks - Fred |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Workbook
Fred,
Just kill it!.... no really... Try this: Kill "C:\Documents and Settings\Administrator\Desktop\Book1.xls" Of course you need to use the right file name. Also note you will have to manage errors, such as File Not Found or Permission Denied (when the workbook is open). But Kill will work.... -- Charles www.officezealot.com "Fred" wrote in message ... I've written some code that creates a workbook, emails it to specific users, then closes it. I'd like to have my code go in a delete the workbook. Any suggestions? Thanks - Fred |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Workbook
That's perfect. Thanks!
-----Original Message----- Fred, Just kill it!.... no really... Try this: Kill "C:\Documents and Settings\Administrator\Desktop\Book1.xls" Of course you need to use the right file name. Also note you will have to manage errors, such as File Not Found or Permission Denied (when the workbook is open). But Kill will work.... -- Charles www.officezealot.com "Fred" wrote in message ... I've written some code that creates a workbook, emails it to specific users, then closes it. I'd like to have my code go in a delete the workbook. Any suggestions? Thanks - Fred . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
deleting workbook | New Users to Excel | |||
how to protect workbook from deleting | Excel Discussion (Misc queries) | |||
Deleting Workbook from others | Excel Worksheet Functions | |||
deleting macros that are not really in my workbook? | Excel Worksheet Functions | |||
How do I prevent someone from deleting a workbook? | Excel Discussion (Misc queries) |