View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default how to run a command from a cell

Is 1032, 1033 etc the name of text files? If so, then check out Hyperlink
function.

You will need the .txt extension on the file names (1032.txt) and ensure
that Notebook.exe is the default application for .txt files.

Example of Hyperlink function showing the path to the .txt files and
concatenation of the filenames in Column A.

=HYPERLINK("C:\Users\Ossie\Documents\Text Editor\" & A2)

If you need to edit a cell with a hyperlink then click on the cell and hold
the button until you see the cross then you can edit it without it activating
the hyperlink.


--
Regards,

OssieMac


"Seede" wrote:

i have a list of filenames in Column A. i want to be able to setup links in
Column B that would launch a executable with the value of associated row in
Column A
for eg

id Launch
1032 Notepad.exe 1032
1033 Notepad.exe 1033
1034 Notepad.exe 1034
1035 Notepad.exe 1035