VBA, TCP/IP from VBA?

TCP/IP from VBA?

Author	Message
chris.. #1 / 4	TCP/IP from VBA? Long time no see! Although I suspect nobody remembers who I am anyway... sniff, sniff. For those of you who do, I moved to London and am now doing Excel VBA stuff but I thought I'd ask my question here as it was my old haunt and it's not specific to any app. I am wanting to open a TCP/IP connection from VBA. I've done this using VB but to be honest I can't remember how I did it - I've no doubt it was some sort of custom control. Does anyone have any idea how to do this from VBA, or even where I could vaguely start? I may not be asking the right question; what I am actually wanting to do is to chat a message onto an IRC channel (we use IRC internally at my new employer - it's a fantastic idea and I'd recommend it to anyone!). Are there any controls that could help me with this? Any help much appreciated - having some trouble here... Happy New Year, etc, Chris Sent via Deja.com http://www.--*.com/ Before you buy.
Sat, 31 Aug 2002 03:00:00 GMT

Jay Freedma #2 / 4	TCP/IP from VBA? Hi, Chris, Long time no see, indeed! Glad to hear you're doing OK. To do TCP/IP from VBA, I think all you need is the standard Winsock control. You should have Mswinsck.ocx in your Windows system directory. Right-click the VBA userform controls palette and check the box for "Microsoft Winsock Control". Set the Protocol property to sckTCPProtocol. Hitting F1 will get you some wimpy VB help on the control's properties and methods, but MSDN has better help and some sample code. HTH Quote: > Long time no see! Although I suspect nobody remembers who I am anyway... > sniff, sniff. > For those of you who do, I moved to London and am now doing Excel VBA > stuff but I thought I'd ask my question here as it was my old haunt and > it's not specific to any app. > I am wanting to open a TCP/IP connection from VBA. I've done this using > VB but to be honest I can't remember how I did it - I've no doubt it was > some sort of custom control. Does anyone have any idea how to do this > from VBA, or even where I could vaguely start? > I may not be asking the right question; what I am actually wanting to do > is to chat a message onto an IRC channel (we use IRC internally at my > new employer - it's a fantastic idea and I'd recommend it to anyone!). > Are there any controls that could help me with this? > Any help much appreciated - having some trouble here... > Happy New Year, etc, > Chris > Sent via Deja.com http://www.deja.com/ > Before you buy.
Sat, 31 Aug 2002 03:00:00 GMT

Bill Coan [Word MVP #3 / 4	TCP/IP from VBA? Hi Chris, You have a lot of nerve sneaking back in here with a question rather than an answer. Why not hang around a while and help out? <g> -- Bill Coan Macros, templates, wizards, add-ins for Word For more information, visit: www.wordsite.com Quote: > Long time no see! Although I suspect nobody remembers who I am anyway... > sniff, sniff. > For those of you who do, I moved to London and am now doing Excel VBA > stuff but I thought I'd ask my question here as it was my old haunt and > it's not specific to any app. > I am wanting to open a TCP/IP connection from VBA. I've done this using > VB but to be honest I can't remember how I did it - I've no doubt it was > some sort of custom control. Does anyone have any idea how to do this > from VBA, or even where I could vaguely start? > I may not be asking the right question; what I am actually wanting to do > is to chat a message onto an IRC channel (we use IRC internally at my > new employer - it's a fantastic idea and I'd recommend it to anyone!). > Are there any controls that could help me with this? > Any help much appreciated - having some trouble here... > Happy New Year, etc, > Chris > Sent via Deja.com http://www.deja.com/ > Before you buy.
Sat, 31 Aug 2002 03:00:00 GMT

Chris Ra #4 / 4	TCP/IP from VBA? Ahem. Thanks for the help, incidentally, guys - I know have a fully functional IRC client running from Excel. Well, sort of fully functional. No error checking, or anything like that, but it's a decent start... I haven't been around for a bit because I'm working pretty long hours and I seem to be spending almost the whole of the rest of the time either in the pub or in bed. However, I have now set up outlook express on my home machine and I will endeavour to play a bit more of a part in this ng! Of course, I'm saying this on a mild Sunday afternoon... on the way to work tomorrow at 6:15am I may have different ideas... Chris Quote: > Hi Chris, > You have a lot of nerve sneaking back in here with a question rather than an > answer. Why not hang around a while and help out? <g> > -- > Bill Coan > Macros, templates, wizards, add-ins for Word > For more information, visit: www.wordsite.com Quote: > > Long time no see! Although I suspect nobody remembers who I am anyway... > > sniff, sniff. > > For those of you who do, I moved to London and am now doing Excel VBA > > stuff but I thought I'd ask my question here as it was my old haunt and > > it's not specific to any app. > > I am wanting to open a TCP/IP connection from VBA. I've done this using > > VB but to be honest I can't remember how I did it - I've no doubt it was > > some sort of custom control. Does anyone have any idea how to do this > > from VBA, or even where I could vaguely start? > > I may not be asking the right question; what I am actually wanting to do > > is to chat a message onto an IRC channel (we use IRC internally at my > > new employer - it's a fantastic idea and I'd recommend it to anyone!). > > Are there any controls that could help me with this? > > Any help much appreciated - having some trouble here... > > Happy New Year, etc, > > Chris > > Sent via Deja.com http://www.deja.com/ > > Before you buy.
Thu, 05 Sep 2002 03:00:00 GMT

Page 1 of 1

[ 4 post ]