check if file exists using fso. then save with an incremental number

[john34]

Hi,
I am trying to save a file with an incremented file number using fso.
I know how to check for an individual file name but need to add some sort of loop through the folder and save each file. starting a new file each time.

Data is filled into a form then added to the file then saved as an incremented number.

Im quite new to vba so think I need treating with kid gloves :0)

[JBeaucaire]

But what happens if one of your incremented files previously saved gets deleted or moved, accidentally?

I would recommend you write a text file into the same directory that explicitly lists what the next number should be, and when the save is done, write the next number into that text file.

Please Login or Register  to view this content.

[john34]

Hi, thanks for the quick reply.

I see where your going with this but....
I only need to start from 1 for each customer which has their own folder.
I have tried using dir before but each time I start a new file the numbers reset and it overwrites the old file.
that's why I thought using fileexists would be best?

[JBeaucaire]

Nah. I would use the method described above. The plumbing is minimal and as shown, it would create the NUMfile.txt as needed in each fPATH as you determine that path with your own methods. Your FileExists method can probably be wrangled into working, it's just going to be more plumbing and looping, unnecessary in my opinion. I stand by my suggestion, adapting for your use in each client folder.

[john34]

Hi again.

You are right.....
However... when it saves the first file it is fine, but when the next ones are written it adds a space before the number?
it woud be fine but im importing the files into another programme that doesn't like spaces.


Thanks again

[JBeaucaire]

Try changing the DIM to fNUM As Long

[john34]

Hi,

Changing to fnum as long returns a 'type missmatch'

[JBeaucaire]

No, that didn't work. I've edited the code above with a tweak that will keep those spaces from being written into the file. Sorry about that.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[john34]

Thanks.

All sorted