Here's a link of the sort I was looking for (or rather "talking about" - I
didn't bother to look for it) last night. This lists a number of functions
that enable VBScript to get data about the machine it's running on:

http://msdn.microsoft.com/en-us/libr...53(VS.85).aspx

If you explore around a little you'll probably also find, in nearby links on
their tree, more information of the same sort.

--- "Daddy Mac will make ya JUMP JUMP" wrote:
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.