Hello,
I am trying to protect my workbook from being shared with other companies. I would like to use vba to look for a certain file in a certain directory and if it is there to do nothing or if it is missing to run a module that will delete all existing modules.
I have found a module online that removes everything, but how would I accomplish looking in a specific directory for a certain file and either do nothing if it is there or run the self destruct sequence?
I am trying to protect my workbook from being shared with other companies. I would like to use vba to look for a certain file in a certain directory and if it is there to do nothing or if it is missing to run a module that will delete all existing modules.
I have found a module online that removes everything, but how would I accomplish looking in a specific directory for a certain file and either do nothing if it is there or run the self destruct sequence?