Hi Garry,

Am Wed, 14 Aug 2013 22:43:30 +0200 schrieb Claus Busch:

Therefore it is important to know what xl version is used and how is
referred (with name or with a range)

and I don't know if validation can be opened in another language system
without problems because of the separators.


Regards
Claus B.

Validation.Formula1 is a read only property and so can be accessed via
automation in a normal fashion. What's important is to get the
qualified refs correct! IMO, this is the #1 problem with COM
automation; people don't get the object refs properly initialized and
so nothing works. (Same happens using VB6 or C++)

--
Garry

Free uenet access at http://www.eternal-september.org
Classic VB Users Regroup
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion