Wednesday 26 September 2007

Drop down list in Excel

I always have a hard time remembering how to make dropdown lists in Excel, her is a nice tutorial of how to do it:
Excel dropdown

And when you make a mistake, as me, this tutorial shows how to edit the list.

edit dropdown

Thursday 20 September 2007

Playing with sockets in vb.net

I am having trouble with sockets. I send a message and want to retrieve some information. Until now I thought that it was the receive which gave me the problems, but in fact the problem arrives before. Cause the send method throws a SocketException with the text “The attempted operation is not supported for the type of object referenced”.

nb = s.Send(ByteSend, ByteSend.Length, SocketFlags.Peek)

Now this doesn’t really help me. So I looked for the Error code, which were 10045. Looking in the error code list (link) gave me the following additional knowledge (or whatever you want to call this message) :
Windows Sockets Error Codes:

WSAEOPNOTSUPP 10045
Operation not supported.
The attempted operation is not supported for the type of object referenced. Usually this occurs when a socket descriptor to a socket that cannot support this operation is trying to accept a connection on a datagram socket.


Now did that help. I ended giving up on the code so I cant really tell you what the solution is. But for reference, I choose to publish this post anyway. Sorry