I have a main folder that has a number of subfolders. When a file is added to any of the subfolders a macro should run......but this macro modifies the added file(triggered file)....How can I get the path of the triggered file.
I also want the macro to run only when a file is added. The macro should not run when the file is deleted. Please suggest.
Thanks