Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
replacing value in formula from outside worksheet?
If I understand correctly your question, then you might want to use the find
replace feature. "Mike" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
replacing value in formula from outside worksheet?
I believe find/replace would change the data; I'm trying to replace a
value in the formula - Mike On Mar 24, 9:36*am, art wrote: If I understand correctly your question, then you might want to use the find replace feature. "Mike" wrote: 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- Hide quoted text - - Show quoted text - |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
replacing value in formula from outside worksheet?
No. try it, it can change the value of the formula as well.
"Mike" wrote: I believe find/replace would change the data; I'm trying to replace a value in the formula - Mike On Mar 24, 9:36 am, art wrote: If I understand correctly your question, then you might want to use the find replace feature. "Mike" wrote: 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- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
replacing value in formula from outside worksheet?
You cannot do anything from the command line other than open a specific
workbook. To make changes upon opening, you would require workbook_open event code in the workbook. Gord Dibben MS Excel MVP On Mon, 24 Mar 2008 06:10:52 -0700 (PDT), Mike wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replacing a corrupt worksheet | Excel Worksheet Functions | |||
help on replacing this formula | Excel Discussion (Misc queries) | |||
Replacing half a formula | Excel Discussion (Misc queries) | |||
replacing text within a formula | Excel Worksheet Functions | |||
Replacing letters for figures in formula | Excel Discussion (Misc queries) |