overwrite existing file

Hi I have this save button, that saves: 3 sheets into pdf 4 sheets into a new workbook (xlsm) 1 sheet into a new copy inside the workbook My problem is if i want to save the sheets again it dosn't overwrite the old one. So my question is how to change the code so it overwrite existing files...

Hello, Question is in bold below! I've recently been pulled into a new team at work. There is a spreadsheet we all use and populate/update with various bits of data many times a day. One of my biggest frustrations (already!) is people overwriting changes I make to the spreadsheet because...

Hello, I'm using this code to move all my Excel files from 1 folder to another. The code is working file. I need your help to edit the code to overwrite the files in the destination folder if the file names in the source & destination folders are the same. I've tried Application.DisplayAlerts =...

I am trying to build a form to submit data to a second worksheet (basically a database) but would like to be able to recall existing entries to update. I cannot figure out how to overwrite an entry with a given field. So sheet1 has 12 cells and sheet2 will have 20-30 entries, each row having...

Can someone please let me know what is wrong with the code below? I am trying to unzip a file using winzip64 and I also want to overwrite any existing files that are extracted. Currently the code runs without errors but it also doesn't extract the file to the location. Sub...

When run, my macro prompts the user to select a file to copy, which it then copies the specified sheet & pastes to a new sheet. The selected file will then close and the macro then formats, deletes, etc. the data in the copied sheet. I then want to save this new formatted file as the name of the...

Hi All, The exact opposite of this question has been asked many times, and I have used the solution... but the time has come where I need to know if the user has selected No or Cancel to overwrite an existing File. I do not want to hide this alert. when using the code...