Passing commands to unix from VBA EXCEL

Passing commands to unix from VBA EXCEL

• AWC

  Hello,

  This appears to be the information I am looking for but I'm struggling a bit.

  All I need to do is create in a VB Script is a call to a UNIX command.

  Basically I want to kick off a script in a UNIX environment and that's all.

  Is that feasible

  I see what you are saying about opening a Telnet how do I pass the command

  Thanks in advance for any help or direction.

  Dean

  
  
  

• Darsant

  Per one of our support engineers:
  
  

  Yes, it’s doable. Basically, we have following ways:< xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

  Telnet

  ==================

  1.       I suppose most of the UNIX system supports Telnet protocol. We have to leverage WinSock API to build a telnet client. Here’re some 3^rd party sample codes for telnet client.

  Telnet Client

  http://www.applevb.com/sourcecode/telnet.zip

  http://www.planet-source-code.com/vb/scripts/ShowCode.asp txtCodeId=36934&lngWId=1

   

  2.       We can leverage SHELL and the telnet command. We can leverage ‘CreatePipe’ API to redirect the SHELL output to Excel VBA code and parse the string we get.

  CreatePipe

  http://msdn.microsoft.com/library/default.asp url=/library/en-us/ipc/base/createpipe.asp

  How To Create a Process for < xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com:office:smarttags" />Reading and Writing to a Pipe

  http://support.microsoft.com/default.aspx scid=kb;en-us;173085

  A 3^rd Sample of CreatePipe

  http://www.mentalis.org/apilist/CreatePipe.shtml

  3. Wrap the Telnet function into a COM for VBA, and then call in from Excel.

  Web Service

  ==================

  We may publish the specific UNIX command as Web Service. On Office side, we can leverage Office Web Service Toolkit

  What's New in the Microsoft Office 2003 Web Services Toolkit

  http://msdn.microsoft.com/library/default.asp url=/library/en-us/odc_wst2003_ta/html/odc_WSTKNew.asp

  Calling XML Web Services from Office VBA Using the Web Service References Tool

  http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnxpwst/html/odc_ofwsrt.asp

  Articles

  ================

  UNIX Application Migration Guide

  http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnucmg/html/ucmglp.asp

  I recommend you reading Chapter 6.

  http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnucmg/html/UCMGch06.asp

   
  -brenda (ISV Buddy Team)

  
  
  
• Passing commands to unix from VBA EXCEL