delete file

Hi all, I currently have a data overview that draws data through power query from a folder in my windows computer: However, I plan to update this folder rapidly every week and I was wondering if it would be possible to create two macros attached to VBA codes, where they do the following: 1)...

Hi everyone, Iam trying to write a small code using the KILL Command to delete a file called "Monthly Summary.xlsm" from the current folder. Thank you

First of all, thank you for all the support I got here during my previous question. I much appreciate it. I am still learning VBA, slowly getting the hang of it, but now I've ran across a complex problem which I have just no idea how to handle. Here is how it goes. I have my workbook stored...

I am using Excel 2007 and Windows Vista. I am using a set of 40 spreadsheets for tracking sporting events and sorting out the results and then the winners name and the number of competitors in each event is linked to a master tally sheet for review. I also use the master tally sheet to...

I have a summary file that contains several tabs for each supplier, and summarizes that data on the Summary tab. The data needs to be sent each month to each supplier. I have a macro that copies the data for each supplier into a separate workbook, and saves the workbook with the Supplier name...

Hi, I have the following code: Sub DeleteFile () Dim TestFile As workbook Set TestFile = ActiveWorkbook ' switch to another defined file ' do some stuff TestFile.Close Save = False Kill TestFile End Sub The macro stops at the Kill TestFile line with error message: "Run-time...