I would like to add a Name to a worksheet
programmatically. I don't want to have to add the name
manually and a macro will not work unless it can be run
without having to open the worksheet and run it with mouse
clicks.

I need to define the same Name or names to changing ranges
on the sheet each time the sheet arrives in a folder. I
can run a script or .exe on the xls file based on an
existence criteria.


Can this be done?