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>
