How to open an external tool directly from an Hyperlink?

[furbiuzzu]

Hi guys, here's my problem:

I've an excel sheet that needs an external program to download data and

import them on excel.
Since both sheet & program have to be downloaded from the web (by many
users) i need to create a 'universal' Hyperlink inside the excel sheet
able to open the program located somewhere on users' hard disk.


When i've created this link on my file (in MY desktop), simply i've
followed program's path from Excel hypertestual-window, and it works
fine. But people told me that it's impossible to open the
needed-program (probably because it's located in a different directory)

when they call it (using My-desktop link, "OBVIOUS, i thought").


So, how could i solve this problem ???


thanks in advance for your attention!

 

[Gary''s Student]

Use the SHELL command to start the external program running. It gives you
lots of options on either giving the external program focus or not, or how to
automate the actions of the external program.

 

[furbiuzzu]

thanks a lot.
i'm going to study it deeply

 

[furbiuzzu]

sorry but a can't find such command in my VBE guide.
where can i find something about it ???

 

[Gary''s Student]

Pull-up VBA Help and search for SHELL. ITs there.