View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Henning Voitz Henning Voitz is offline
external usenet poster
 
Posts: 1
Default keep formula after typing in a value in a excel cell

Hi there,

my problem is, that i need something like:

there is a function in a excel-cell (for example '=setvalue("sqlserver",
"DB", "table")').
now i type in a value (for example 100) then the function "setvalue" must
write this value
(100) in the server, db and table from the parameters. after leaving the
cell the formula
is still the same and only the value 100 ist visible for the user. and if i
go back to the
cell than i can see the function in the menubar.

there is a product from applix (TM1) and they did it. the problem is, that
the souce code
is protected ;)

Is there anyone who has an idea or know how to handle it !?

thanks for your help!
Henning