Hello experts,

I'd like to find a method/script to only execute an excel macro based
on a users existing file listing on their computer ( or it could be a
pre-existing setting; ie. their IP or MAC address). Ideally I'd like
to have a macro check for the existence of a certain file (or password
phrase encoded in the file) on the directory of a users computer, if
YES then execute macro, ELSE don't do anything. This is all done in
the background right before the event that usually triggers the
primary macro, which is an ftp command line script.

My guess is creating a batch file that executes in a windows shell and
outputs a value that could be read, but I'm not sure if that's the
best way to achieve what I want.

I want to avoid using a pop-up form and password inside the excel file
- this is currently what I already have.

Thank you for your help,

-Doug Jr.