Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2007
    Posts
    1

    Unanswered: Running programs using VBA

    I should preface this by explaining that I know nearly nothing of VBA. I have an issue that I'm trying to resolve, and all my clues are leading me to the impression that using VBA is the only way to accomplish my task.

    I am trying to integrate the ability to launch a program with command line arguments by clicking on a cell. More specifically, I'm trying to launch vncviewer, and point it to an IP address.

    the command line would look like:

    c:\program files\ultravnc\vncviewer.exe 192.168.XXX.XXX

    The only text the cells will have in them is the IP address to the machine with which I would like to initiate a connection, and I'm hoping theres a way to automatically pull that information from the cell and run it in the command. Is there a way to do this? Better yet, is there a relatively simple way to do this?

    Thanks,

    Tyler

  2. #2
    Join Date
    Jul 2003
    Location
    Amsterdam, Nederland
    Posts
    450

    Wink Re

    clicking the cell is a bit more complicated

    put a button next to the cell and do a shell execute on the cell.text

    For an Example, there are more then a million exampes on the web or in the help files on how to do this.

    see google on excel and shellexecute

    or http://support.microsoft.com/kb/238245

    here's one with a diffrent angle but you'll general idear
    http://j-walk.com/ss/excel/tips/tip86.htm

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •