open a non-office file using cell data from excel

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
[email protected]
"dcauldwell" <[email protected]> wrote in message
news:[email protected]...
> 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.

On Mon, 16 Jan 2006 10:09:02 +0100, dcauldwell
<[email protected]> 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("C:\Program Files\UltraVnc\vncviewer.exe " &
ActiveCell.Value)
End Sub

Generally command Shell is allowing you to run other apps

> 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.



--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/