File does not exist - error handler

[MichaelS_]

Hi

I got a problem and somehow I am not able to solve it. The purpose of the code is to update all files listed on the coverage.xls file (e.g. R:\APS\AMR\REBR\SwissCompanies\SIG\SIG.xls. Sometimes it happens that a company on the coverage.xls file does not any longer exist, so it need get the next company (i+1). To handle that in a proper way I need to have an error handler. But I don’t know how. Could anybody help me?

Thanks.
Michael

Please Login or Register  to view this content.

[stevebriz]

You can check to see if a file exists using the function below :
This is on the msdn website.
http://msdn.microsoft.com/library/de...ce09072000.asp

Please Login or Register  to view this content.

[MichaelS_]

Thank you for the function DoesFileExist. Now I got the function, but how can I implement the function in my module?

Thanks
Michael

[MichaelS_]

I would very much appreciate if anybody could help me.

Thanks a lot.
Michael

[derekbrown]

Hi Michael,

If you add the code above to your module, then call it like so:

'your code

DoesFileExist(<enter your file in here>)

'more of your code