theta
04-23-2013, 06:38 AM
When working with object names, properties, logical statement you sometimes need to check the returned value (or a string).
When moving between different version of Excel (English, German, French) this can change e.g.
Class becomes Klasse
True becomes Wahr
False becomes Falsh
Worksheet becomes Werkblad
Workbook becomes Werkboek
Is there a way to get the application name for an object, property or type ? e.g.
Application True = "Wahr"
Application Workbook = "Werkboek"
This would allow me to use application default named instead of hard coding references. Real world example :
If vc.Type = 100 Then c00 = IIf(vc.Properties.Count = 66, "werkblad", "werkboek")
When moving between different version of Excel (English, German, French) this can change e.g.
Class becomes Klasse
True becomes Wahr
False becomes Falsh
Worksheet becomes Werkblad
Workbook becomes Werkboek
Is there a way to get the application name for an object, property or type ? e.g.
Application True = "Wahr"
Application Workbook = "Werkboek"
This would allow me to use application default named instead of hard coding references. Real world example :
If vc.Type = 100 Then c00 = IIf(vc.Properties.Count = 66, "werkblad", "werkboek")