close

can I open a non-office file using cell data from excel.
I want to use data calculated within excel, which I have then put into a
string, to then be used to open the file, to which that string refers.

Have a look in vba help for SHELL

--
Don Guillett
SalesAid Software

quot;dcauldwellquot; gt; wrote in message
...
gt; can I open a non-office file using cell data from excel.
gt; I want to use data calculated within excel, which I have then put into a
gt; string, to then be used to open the file, to which that string refers.
On Mon, 16 Jan 2006 10:09:02 0100, dcauldwell
gt; wrote:

I'm using something like this for application VNC. In excel there is
column with ip addresses and this macro (I've created a module):

Sub VNC()
RetVal = Shell(quot;C:\Program Files\UltraVnc\vncviewer.exe quot; amp;
ActiveCell.Value)
End Sub

Generally command Shell is allowing you to run other apps

gt; can I open a non-office file using cell data from excel.
gt; I want to use data calculated within excel, which I have then put into a
gt; string, to then be used to open the file, to which that string refers.
--
Using Opera's revolutionary e-mail client: www.opera.com/mail/

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()