delete a workbook

Sub Deleteexcel() 'You can use this to delete all xls files in the folder Test On Error Resume Next Kill Application.ActiveWorkbook.Path"*.xls" On Error GoTo 0 End Sub I have code above that is trying to delete every file with xls extension. I have wrong syntax, but no idea...

Hello I have a macro which pushes out the current excel workbook that I am in to various different SharePoint sites. I would like to be able to delete the previous version of the file. I have the name of the previous file stored in a variable called 'OldFileName'. I check that the file exists...

I have this code that I got from another source and what I am trying to do is delete the old copies of this back up so that there is only the most recent backup copy. If you could point me in the right direction that would be greatly appreciated. Thank you Private Sub Workbook_BeforeSave(ByVal...

Hi guys, These are my Subs: Sub Undosave() Application.ScreenUpdating = False Application.OnTime Now, "Undosave2" ThisWorkbook.Close SaveChanges:=False End Sub Sub Undosave2() Application.Workbooks.Open ("C:\Users\Seth\Documents\Costing Program\Process Costing\Process Costing Updating")...

Hello all I have been new to VBA and have been working in it for about 2 weeks. I am trying to aggregate a data set from a folder with multiple workbooks into a single workbook. The code bellow does that but I also want to delete the copied workbook after it is placed in the "Master workbook"...

Hi all,</SPAN> It has been two full days that I’m trying to solve this issue, but no lack so far. My knowledge in programming with VBA are limited, so I hope you know how to solve this.</SPAN> Basically, I open a program as an object with VBA and I pass to this object some date. The program...