Checking if file name already exists

[Rob T]

Right, this is the code I have which generates a Bill of Materials (BoM) in a different format from our BoM. The code which actually does the copying across I haven't included as it's not particularly relevant (that's the "sub CopyData"). The only problem with this code is that if you enter a filename which already exists and (at the relevant time) click "no" to the overwrite option the macro crashes out.

Is there any way to check when the user first enters the file name whether it is the same as another file in that folder?

Many thanks in advance,

Rob

[mudraker]

This wil test if the file exists

Please Login or Register  to view this content.

[Rob T]

Thank-you very much mudraker, works like a charm!

Cheers,

Rob

[mudraker]

Glad to hear that it helped you solve your problem