Macro to not save a file if it already exists

[sandbach]

Hello I have a macro that saves data to a specific file path, but if this already exists i want it to not save the data. A bit of the line of code is

Please Login or Register  to view this content.

Can anybody give me any lines of code which would make it not carry out the save command? Any help really would be apprceiated.


Kind regards

Joe

[Dom83]

Hi sandbach,

The Dir() function will do this for you:

Please Login or Register  to view this content.

Thanks,
Dom

[sandbach]

Thanks Dom,

That is fantastic!!!!!!!!!!!!!