thanks for the input... i have tested this several ways..
-----------------
activation: directory modification, points to desktop c:\users\mts\desktop
MACRO:
if not file :\users\mts\desktop\indeedjobs.xls
macro stop
else
run my macro
-----------------------
when i run my extraction SW and it saves this indeedjobs.xls file onto my desktop, nothing happens, ME does not run the macro
BUT...when i double click this file, the ME macro runs, the problem is that is continues to run, so if i try to close down indeedjobs.xls & dont save changes, it just runs the macro again and opens the file again. If i save it with another name, it runs the macro again as well, (the original file name still exists on the desktop) so i have no other option but to disable this macro...i have Win7 and Excel 2007.
is the issue the desktop "folder", there seems not to be an activation event, BUT the macros If NOT file causes the macro to loop... see attached JPG