Oups,
Sorry all, it works fine for me too. I use an array to parse multiple
colors and I made a mistake.
Thanks for your time and sorry again.
Youri
Charles Yeomans wrote:
This works for me.
dim v as Variant = "&cff0000"
dim c as Color = v
Charles Yeomans
On Nov 19, 2006, at 4:29 PM, Youri wrote:
Terry,
Using this I get a : "Type Mismatch Error
Expected Color, but got Variant.
Youri
Terry Ford wrote:
On Nov 19, 2006, at 12:49 PM, Youri wrote:
How can I retrieve (reconstruct) my colors from text to a Color
datatype?
Use a variant as an intermediate conversion step.
Dim v As Variant
t = f.OpenAsTxtFile
s = t.readall
v = NthField(s,",",1)
Cal.BackColor = v
Terry
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
