View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike[_4_] Mike[_4_] is offline
external usenet poster
 
Posts: 5
Default replacing value in formula from outside worksheet?

We know we can start up a spreadsheet from the command prompt: excel
<spreadsheetname.
We've seen batch files which allow one to specify a replacable
parameter in the batchfile from the command line. I'm trying to do
something similar in Excel.

Assume A1:A4 is populated with the names Bob,Ted,Carol,Alice, and I've
written the following formula for Column B: =If((A1:A4)="Bob",1,0).
this will return a '1' in B1, and "0" in B2-B4.

Now, I want to change "Bob" to "Ted" from the command line. I"m
looking for someway to identify a field as replacable, and to perform
the replacement.

Any suggestions? - Mike