Dim tmp As String
Open "c:\wordlist.txt" For Binary As #1
tmp = Space(LOF(1))
Get #1, , tmp
Close #1
'this is a test....never mind I found the code
words = Split(tmp, vbCrLf)
End Sub
JPnyc rocks!! (Just ask him!)
If u have your answer please go to the thread tools and click "Mark Thread Resolved"
Your problem is this: VB doesn't put the color values in the same order that the web does. Here is some code i have previously written for that very function:
[code]
dim red as byte
dim green as byte
dim blue as byte
dim webcolor as string
call splitvbcolor (object.color, blue, green, red)
webcolor = zeropad(rgb(red, green, blue))
Sub SplitVBColor(VBColor As Long, Blue As Byte, Green As Byte, Red As Byte)
Red = VBColor And &HFF
Green = (VBColor And &HFF00&) \ &H100&
Blue = (VBColor And &HFF0000) \ &H10000
End Sub
Function ZeroPad(HexNumber As String) As String
ZeroPad = Left$("000000", 6 - Len(HexNumber)) + HexNumber
End Function
If you're interested, i have attached a module i am working on currently with the above functions and a couple of other neat color-manipulating ones you might find interesting.