| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I force the file to over write the existing file
have the follow code which works fine unless a file of that name already
exists. wbkNew.SaveAs sFileName How can I force the file to over write the existing file. Ed |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I force the file to over write the existing file
Try:
On Error Resume Next kill sFileName On Error GoTo 0 sbkNew.SaveAs sFileName Cheers - Jeff "Ed" wrote: have the follow code which works fine unless a file of that name already exists. wbkNew.SaveAs sFileName How can I force the file to over write the existing file. Ed |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User replaces existing file with blank during file open | Excel Discussion (Misc queries) | |||
| How can I force the file to over write the existing file | Excel Programming | |||
| Force Save over existing file | Excel Programming | |||
| Importing text file, only option to edit existing file | Excel Discussion (Misc queries) | |||
| Write over existing file with no Prompt | Excel Programming | |||
Linear Mode
