Save As to search subdirectories

[mgiehm]

I have a file that saves itself based upon a cell value. It currently checks to see if that file exists already. The issue I'm running into is that I need it to check subfolders and not just the main directory. The files will get moved into different folders and I need to ensure no duplication happens. Any help is greatly appreciated.

 

[John_w]

Which version of Excel do you have? If Excel 2003 (or earlier, I believe) you could use the built-in Application.FileSearch to see if the file exists. Otherwise you could use the FileSystemObject FileExists method within a recursive routine which searches subfolders.

 

[mgiehm]

I have looked into it an unfortunately cannot figure it out. It needs to save based upon cell C5's value then -1. I need it to save sequentially as the value in cell C5 may be duplicated. Let's say C5 is 1234 it would save as 1234-1.xls than if another is made it would see that 1234-1 has been created already and save as 1234-2 and so on. The issue is that 1234-1 may have been moved to a sub directory. Is there anyway to do this?