VB Commands

Hi Ronnie, thanks for your query. The answer to your question depends a lot on the software you are trying to connect to! Essentially, when connecting to, say Word, from Excel VBA you declare a reference to the Word object (i.e. tell Excel Word actually exists!) throught Tools-References. You can then control the Word object model from Excel.

However, to control completely different software applications you have to gain access to their individual API (Application Programming Interface). This is a long way beyond the scope of this forum I'm afraid, but have a look here for a useful (VB, not VBA) introduction to this topic.

http://allapi.mentalis.org/vbtutor/tutmain.shtml

Hope this helps,

Anthony