Defining Names Programmatically

  • Thread starter Thread starter Dave Yutzler
  • Start date Start date
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?
 
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)
 
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
 
Back
Top