Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default VBA Socket / Winsock control / issues? Demo app provided.

VBA Socket / Winsock control / issues? Demo app provided.

I adapted a Winsock control demo from VB into Excel VBA. Am looking to do
some potentially taxing communications through a socket to and from Excel
spreadsheets. Was wondering if anyone else has done this and if there are
any issues with Excel that emerge as the speed ramps up:

*Dropping events (what are the various states where Excel stops processing
events, etc.)
*Cuing back Winsock messages (how big a cue? FIFO?)
*Any type of throttling issues?
*Anything else to be concerned about, or to think about in advance

I'm not looking to press the upper limits of what Excel can handle speed
wise and am much more concerned about dropped data or other weird behavior.
The applications are in the Investment and Trading System area where
robustness is critical.

Any help / tips for the uninitiated in this are GREATLY APPRECIATED!!!

To download the sample application see:
http://www.itsdoc.org/wiki/tiki-inde...0and%20Sockets

Rick

Rick \[at\] ITSdoc /[dot org/]
http://ITSdoc.org


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA Control Issues Chris Picklesimer Excel Programming 5 March 15th 06 09:47 PM
Calendar Control issues Michael Malinsky[_3_] Excel Programming 0 July 26th 04 06:01 PM
Socket Programming in Excel Fung Excel Programming 0 July 19th 04 03:39 AM
Use winsock in Excel VBA Grey Excel Programming 0 May 25th 04 09:42 AM
Cannot get appropriate Event fired with WinSock control Tetsuya Oguma[_3_] Excel Programming 0 October 22nd 03 08:14 AM


All times are GMT +1. The time now is 10:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"