Defining Names Programmatically

D

Dave Yutzler

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?
 
B

Bob Phillips

Dave,

Do you mean, can you add a name to a closed workbook? If so, AFAIK, the
answer is no, you would have to open it, add the name, and tghen close it.
Also, how would you know it has arrived in the folder?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
D

David Yutzler

Bob,

I would be glad to open the exel doc in a vbscript. I just don't want
to have to add it through the exel ui. Is there a way to do with
vbscript?

Thanks for your ideas.

Dave


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
Top