C
Christopher Benson-Manica
I am considering creating an application that will primarily depend on
a program written in VBA for Excel acting as a server for several Java
clients. I don't currently own Excel and was hoping I could verify
that the venture was possible before purchasing Office XP for
development.
1) Does VBA for Excel provide socket and networking support
off-the-shelf or with minimal setup? Is support similar for Office XP
and Office 2003?
2) How reliable is the underlying Windsock ActiveX control? A quick
Google search suggested that it might not be. Does anyone have
personal experience to share?
3) How good is performance? I envision a maximum of up to 100 clients
simultaneously sending small (500B-1K per minute) amounts of data to
this server application. Does VBA offer something like a select()
call (similar to the C and Java calls) that will obviate the need to
use multiple threads? Does VBA support multiple threads at all?
4) Does VB.Net integrate with Excel at all or am I forced to stick
with Excel's built-in VBA?
5) If the answers to all these questions are "no", how difficult is it
to integrate an application written in an arbitrary language (say
Java) with a VBA application? Does VBA support named pipes or some
other interprocess comunnication protocol?
I appreciate any insight into these questions.
a program written in VBA for Excel acting as a server for several Java
clients. I don't currently own Excel and was hoping I could verify
that the venture was possible before purchasing Office XP for
development.
1) Does VBA for Excel provide socket and networking support
off-the-shelf or with minimal setup? Is support similar for Office XP
and Office 2003?
2) How reliable is the underlying Windsock ActiveX control? A quick
Google search suggested that it might not be. Does anyone have
personal experience to share?
3) How good is performance? I envision a maximum of up to 100 clients
simultaneously sending small (500B-1K per minute) amounts of data to
this server application. Does VBA offer something like a select()
call (similar to the C and Java calls) that will obviate the need to
use multiple threads? Does VBA support multiple threads at all?
4) Does VB.Net integrate with Excel at all or am I forced to stick
with Excel's built-in VBA?
5) If the answers to all these questions are "no", how difficult is it
to integrate an application written in an arbitrary language (say
Java) with a VBA application? Does VBA support named pipes or some
other interprocess comunnication protocol?
I appreciate any insight into these questions.
