| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete workbook from one location and save workbook to new locatio
I need to be able to save a workbook to a new location and delete the same
workbook from the old location, if not delete then move the file to another folder. I am able to save a file using a named range but with my code I can't seem to be able to delete. I am currently trying with the following code: Sub DeletethenSaveFile() Dim Range As String Set Proj = Sheets("Form").Range("$F$10") DeleteFile "Blah Blah Blah" & Range("Proj") & "2.xls" MsgBox "The requested file has been deleted" ThisWorkbook.SaveCopyAs "Blah Blah Blah" & Range("Proj") & "2.xls" MsgBox "Your file has been saved to it's new location" End Sub Please help! D |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Feature to automatically save back up files to a different locatio | Excel Discussion (Misc queries) | |||
| Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
| Automatically Delete WorkBook 2 modules by using Workbook 1 module | Excel Programming | |||
| Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) | |||
| What commands do you use to name a workbook, save a workbook,open a workbook | Excel Programming | |||
Threaded Mode
