file already exists

Hi All, I created a file with the name Test Progress Report.xlsx which I have duplicated and saved under other names. I've recently deleted a few and had to update the original version. I've now saved another copy under a different name and I keep getting an error message come up when I open it...

' I need some way to determine whether or not a given file exists. The past couple of days have been spent searching the internet and ' trying different pieces of code I've found. None of them work for me.The second workbook, "MasterDataFile.xlsm" was created by me ' and works okay. The problem...

Hi, Long time reader, first time poster... I have a table with with a list of values that represent serial numbers. Im looking for some VBA code that will check a specific directory to see if someone has added a file where the filename contains one of the serial numbers and updates the value...

Hello, I have a code that works well for saving to multiple locations. However, I would like for the code to check for existing files in BOTH locations and if one exist then to save under sme name with different version. i.e testfilev1. Hope I explained that right. thank you very much...

Greetings! I'm working on an portion of code in my workbook to FTP some files. To do that, I'm creating a FTPcmd.txt file via code containing the FTP commands, closing the file and then shelling the FTP command in the CMD window. It looks like the command file is taking too long to complete...

Hi This is my first post, and I'm quite a newbie to VB so please be gentle. I'm having an issue whereby the code that I've written (with a little help) to save the existing file as new, which checks to see if a file already exists with the same name, doesn't run as expected on first run after...